DBA Data[Home] [Help]

APPS.PQP_US_FF_FUNCTIONS dependencies on PAY_ELEMENT_TYPES_F

Line 493: ,pay_element_types_f pet

489: CURSOR c_alien_earn_exist IS
490: SELECT 'x'
491: FROM pay_element_entries_f pee
492: ,pay_element_links_f pel
493: ,pay_element_types_f pet
494: ,pay_element_classifications pec
495: WHERE pee.assignment_id = p_assignment_id
496: AND pee.element_link_id = pel.element_link_id
497: AND pel.element_type_id = pet.element_type_id

Line 512: ,pay_element_types_f pet

508: CURSOR c_alien_taxation IS
509: SELECT 'x'
510: FROM pay_element_entries_f pee
511: ,pay_element_links_f pel
512: ,pay_element_types_f pet
513: WHERE pee.assignment_id = p_assignment_id
514: AND pee.element_link_id = pel.element_link_id
515: AND pel.element_type_id = pet.element_type_id
516: AND pet.element_name = 'ALIEN_TAXATION'