APPS.PAY_IN_24QC_ARCHIVE dependencies on PAY_ELEMENT_TYPES_F

Line 820: ,pay_element_types_f types

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'
824: AND types.legislation_code = 'IN'

Line 895: ,pay_element_types_f types

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'
899: AND entry.effective_start_date BETWEEN g_qr_start_date AND g_qr_end_date

Line 1340: ,pay_element_types_f types

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'
1344: AND types.legislation_code = 'IN'

Line 1358: ,pay_element_types_f types

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'
1362: AND entry.effective_start_date BETWEEN g_qr_start_date AND g_qr_end_date;