APPS.PAY_IN_24QC_ARCHIVE dependencies on PAY_ELEMENT_ENTRIES_F

Line 884: FROM pay_element_entries_f entry

880: AND pai.action_information3 = g_gre_id
881: AND (
882: pai.source_id NOT IN
883: (SELECT entry.element_entry_id
884: FROM pay_element_entries_f entry
885: ,pay_element_types_f types
886: WHERE entry.assignment_id = pai.assignment_id
887: AND entry.element_type_id = types.element_type_id
888: AND types.element_name = 'Income Tax Challan Information'

Line 959: FROM pay_element_entries_f entry

955: SELECT entry.element_entry_id element_entry_id
956: ,entry.assignment_id assignment_id
957: ,NULL last_action_context_id
958: ,pay_in_utils.get_ee_value(entry.element_entry_id,'Challan or Voucher Number')
959: FROM pay_element_entries_f entry
960: ,pay_element_types_f types
961: WHERE entry.element_type_id = types.element_type_id
962: AND types.element_name = 'Income Tax Challan Information'
963: AND types.legislation_code = 'IN'

Line 1446: FROM pay_element_entries_f entry

1442: )
1443: )
1444: AND pai.source_id IN
1445: (SELECT entry.element_entry_id
1446: FROM pay_element_entries_f entry
1447: ,pay_element_types_f types
1448: WHERE entry.assignment_id = pai.assignment_id
1449: AND entry.element_type_id = types.element_type_id
1450: AND types.element_name = 'Income Tax Challan Information'

Line 1464: FROM pay_element_entries_f entry

1460: IS
1461: SELECT entry.element_entry_id element_entry_id
1462: ,entry.assignment_id assignment_id
1463: ,pay_in_utils.get_ee_value(entry.element_entry_id,'Challan or Voucher Number') challan
1464: FROM pay_element_entries_f entry
1465: ,pay_element_types_f types
1466: WHERE entry.element_type_id = types.element_type_id
1467: AND types.element_name = 'Income Tax Challan Information'
1468: AND types.legislation_code = 'IN'