APPS.PAY_IN_24QC_ARCHIVE dependencies on PAY_ELEMENT_ENTRIES_F

Line 819: FROM pay_element_entries_f entry

815: AND pai.action_information3 = g_gre_id
816: AND (
817: pai.source_id NOT IN
818: (SELECT entry.element_entry_id
819: FROM pay_element_entries_f entry
820: ,pay_element_types_f types
821: WHERE entry.assignment_id = pai.assignment_id
822: AND entry.element_type_id = types.element_type_id
823: AND types.element_name = 'Income Tax Challan Information'

Line 894: FROM pay_element_entries_f entry

890: SELECT entry.element_entry_id element_entry_id
891: ,entry.assignment_id assignment_id
892: ,NULL last_action_context_id
893: ,pay_in_utils.get_ee_value(entry.element_entry_id,'Challan or Voucher Number')
894: FROM pay_element_entries_f entry
895: ,pay_element_types_f types
896: WHERE entry.element_type_id = types.element_type_id
897: AND types.element_name = 'Income Tax Challan Information'
898: AND types.legislation_code = 'IN'

Line 1339: FROM pay_element_entries_f entry

1335: )
1336: )
1337: AND pai.source_id IN
1338: (SELECT entry.element_entry_id
1339: FROM pay_element_entries_f entry
1340: ,pay_element_types_f types
1341: WHERE entry.assignment_id = pai.assignment_id
1342: AND entry.element_type_id = types.element_type_id
1343: AND types.element_name = 'Income Tax Challan Information'

Line 1357: FROM pay_element_entries_f entry

1353: IS
1354: SELECT entry.element_entry_id element_entry_id
1355: ,entry.assignment_id assignment_id
1356: ,pay_in_utils.get_ee_value(entry.element_entry_id,'Challan or Voucher Number') challan
1357: FROM pay_element_entries_f entry
1358: ,pay_element_types_f types
1359: WHERE entry.element_type_id = types.element_type_id
1360: AND types.element_name = 'Income Tax Challan Information'
1361: AND types.legislation_code = 'IN'