APPS.PAY_IN_24QC_ARCHIVE dependencies on PAY_ELEMENT_TYPES_F

Line 885: ,pay_element_types_f types

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

Line 960: ,pay_element_types_f types

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

Line 1447: ,pay_element_types_f types

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

Line 1465: ,pay_element_types_f types

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