APPS.PAY_IP_EMPLOYEE_BALANCES dependencies on FND_NUMBER

Line 450: WHERE pbt.balance_type_id = fnd_number.canonical_to_number(p_balance_type_id)

446: FROM pay_defined_balances pdb_call,
447: pay_balance_dimensions pbd,
448: pay_balance_types pbt,
449: pay_element_types_f pet
450: WHERE pbt.balance_type_id = fnd_number.canonical_to_number(p_balance_type_id)
451: AND ((pbt.business_group_id IS NOT NULL AND pbt.business_group_id = p_business_group_id)
452: OR (pbt.legislation_code IS NOT NULL AND pbt.legislation_code = l_legislation_code))
453: AND pet.classification_id = l_classification_id
454: AND pet.element_information10 = fnd_number.number_to_canonical(pbt.balance_type_id)

Line 454: AND pet.element_information10 = fnd_number.number_to_canonical(pbt.balance_type_id)

450: WHERE pbt.balance_type_id = fnd_number.canonical_to_number(p_balance_type_id)
451: AND ((pbt.business_group_id IS NOT NULL AND pbt.business_group_id = p_business_group_id)
452: OR (pbt.legislation_code IS NOT NULL AND pbt.legislation_code = l_legislation_code))
453: AND pet.classification_id = l_classification_id
454: AND pet.element_information10 = fnd_number.number_to_canonical(pbt.balance_type_id)
455: AND pbt.balance_type_id = pdb_call.balance_type_id
456: AND pdb_call.balance_dimension_id = pbd.balance_dimension_id
457: AND ((p_tax_unit_id <> -1 AND pbd.database_item_suffix IN ('_ASG_TU_PTD','_ASG_TU_MONTH','_ASG_TU_TQTD','_ASG_TU_TYTD'))
458: OR (p_tax_unit_id = -1 AND pbd.database_item_suffix IN ('_ASG_PTD','_ASG_MONTH','_ASG_TQTD','_ASG_TYTD')))

Line 478: WHERE pbt.balance_type_id = fnd_number.canonical_to_number(p_balance_type_id)

474: FROM pay_defined_balances pdb_call,
475: pay_balance_dimensions pbd,
476: pay_balance_types pbt,
477: pay_element_types_f pet
478: WHERE pbt.balance_type_id = fnd_number.canonical_to_number(p_balance_type_id)
479: AND ((pbt.business_group_id IS NOT NULL AND pbt.business_group_id = p_business_group_id)
480: OR (pbt.legislation_code IS NOT NULL AND pbt.legislation_code = l_legislation_code))
481: AND pet.classification_id = l_classification_id
482: AND pet.element_information10 = fnd_number.number_to_canonical(pbt.balance_type_id)

Line 482: AND pet.element_information10 = fnd_number.number_to_canonical(pbt.balance_type_id)

478: WHERE pbt.balance_type_id = fnd_number.canonical_to_number(p_balance_type_id)
479: AND ((pbt.business_group_id IS NOT NULL AND pbt.business_group_id = p_business_group_id)
480: OR (pbt.legislation_code IS NOT NULL AND pbt.legislation_code = l_legislation_code))
481: AND pet.classification_id = l_classification_id
482: AND pet.element_information10 = fnd_number.number_to_canonical(pbt.balance_type_id)
483: AND pbt.balance_type_id = pdb_call.balance_type_id
484: AND pdb_call.balance_dimension_id = pbd.balance_dimension_id
485: AND ((p_tax_unit_id <> -1 AND pbd.database_item_suffix IN ('_PER_TU_MONTH','_PER_TU_TQTD','_PER_TU_TYTD'))
486: OR (p_tax_unit_id = -1 AND pbd.database_item_suffix IN ('_PER_MONTH','_PER_TQTD','_PER_TYTD')))

Line 505: WHERE pbt.balance_type_id = fnd_number.canonical_to_number(p_balance_type_id)

501: FROM pay_defined_balances pdb_call,
502: pay_balance_dimensions pbd,
503: pay_balance_types pbt,
504: pay_element_types_f pet
505: WHERE pbt.balance_type_id = fnd_number.canonical_to_number(p_balance_type_id)
506: AND ((pbt.business_group_id IS NOT NULL AND pbt.business_group_id = p_business_group_id)
507: OR (pbt.legislation_code IS NOT NULL AND pbt.legislation_code = l_legislation_code))
508: AND pet.classification_id = l_classification_id
509: AND pet.element_information11 = fnd_number.number_to_canonical(pbt.balance_type_id)

Line 509: AND pet.element_information11 = fnd_number.number_to_canonical(pbt.balance_type_id)

505: WHERE pbt.balance_type_id = fnd_number.canonical_to_number(p_balance_type_id)
506: AND ((pbt.business_group_id IS NOT NULL AND pbt.business_group_id = p_business_group_id)
507: OR (pbt.legislation_code IS NOT NULL AND pbt.legislation_code = l_legislation_code))
508: AND pet.classification_id = l_classification_id
509: AND pet.element_information11 = fnd_number.number_to_canonical(pbt.balance_type_id)
510: AND pbt.balance_type_id = pdb_call.balance_type_id
511: AND pdb_call.balance_dimension_id = pbd.balance_dimension_id
512: AND ((p_tax_unit_id <> -1 AND pbd.database_item_suffix = '_ASG_TU_ITD')
513: OR (p_tax_unit_id = -1 AND pbd.database_item_suffix = '_ASG_ITD'))

Line 531: WHERE pbt.balance_type_id = fnd_number.canonical_to_number(p_balance_type_id)

527: FROM pay_defined_balances pdb_call,
528: pay_balance_dimensions pbd,
529: pay_balance_types pbt,
530: pay_element_types_f pet
531: WHERE pbt.balance_type_id = fnd_number.canonical_to_number(p_balance_type_id)
532: AND ((pbt.business_group_id IS NOT NULL AND pbt.business_group_id = p_business_group_id)
533: OR (pbt.legislation_code IS NOT NULL AND pbt.legislation_code = l_legislation_code))
534: AND pet.classification_id = l_classification_id
535: AND pet.element_information13 = fnd_number.number_to_canonical(pbt.balance_type_id)

Line 535: AND pet.element_information13 = fnd_number.number_to_canonical(pbt.balance_type_id)

531: WHERE pbt.balance_type_id = fnd_number.canonical_to_number(p_balance_type_id)
532: AND ((pbt.business_group_id IS NOT NULL AND pbt.business_group_id = p_business_group_id)
533: OR (pbt.legislation_code IS NOT NULL AND pbt.legislation_code = l_legislation_code))
534: AND pet.classification_id = l_classification_id
535: AND pet.element_information13 = fnd_number.number_to_canonical(pbt.balance_type_id)
536: AND pbt.balance_type_id = pdb_call.balance_type_id
537: AND pdb_call.balance_dimension_id = pbd.balance_dimension_id
538: AND ((p_tax_unit_id <> -1 AND pbd.database_item_suffix = '_ASG_TU_ITD')
539: OR (p_tax_unit_id = -1 AND pbd.database_item_suffix = '_ASG_ITD'))