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 2740: pay_element_classifications pec,

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

Line 2924: pay_element_classifications pec

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