DBA Data[Home] [Help]

APPS.PAY_IN_TERMINATION_PKG dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 1394: pay_element_classifications pec,

1390: SELECT pee.element_entry_id
1391: , pee.object_version_number
1392: ,pee.effective_start_date
1393: FROM pay_element_types_f pet,
1394: pay_element_classifications pec,
1395: pay_element_entries_f pee,
1396: pay_element_entry_values_f peev,
1397: pay_input_values_f piv
1398: WHERE pet.classification_id = pec.classification_id

Line 2743: pay_element_classifications pec,

2739: SELECT pet.element_name
2740: ,piv1.default_value
2741: ,pbt.balance_name
2742: FROM pay_element_types_f pet,
2743: pay_element_classifications pec,
2744: pay_balance_feeds_f pbf,
2745: pay_balance_types pbt,
2746: pay_input_values_f piv,
2747: pay_input_values_f piv1,

Line 2927: pay_element_classifications pec

2923:
2924: CURSOR csr_element IS
2925: SELECT pet.element_name
2926: FROM pay_element_types_f pet,
2927: pay_element_classifications pec
2928: WHERE pet.classification_id = pec.classification_id
2929: AND pec.classification_name = 'Information'
2930: AND pet.element_name LIKE '%Excess Advance'
2931: AND pet.business_group_id = p_business_group_id