APPS.PAY_SA_ARCHIVE dependencies on PAY_ELEMENT_TYPES_F

Line 8: ,element_name pay_element_types_f.element_name%type

4: g_debug boolean := hr_utility.debug_enabled;
5:
6: TYPE element_rec IS RECORD (
7: classification_name pay_element_classifications.classification_name%type
8: ,element_name pay_element_types_f.element_name%type
9: ,element_type_id pay_element_types_f.element_type_id%type
10: ,input_value_id pay_input_values_f.input_value_id%type
11: ,element_type VARCHAR2(1)
12: ,uom pay_input_values_f.uom%type

Line 9: ,element_type_id pay_element_types_f.element_type_id%type

5:
6: TYPE element_rec IS RECORD (
7: classification_name pay_element_classifications.classification_name%type
8: ,element_name pay_element_types_f.element_name%type
9: ,element_type_id pay_element_types_f.element_type_id%type
10: ,input_value_id pay_input_values_f.input_value_id%type
11: ,element_type VARCHAR2(1)
12: ,uom pay_input_values_f.uom%type
13: ,archive_flag VARCHAR2(1));

Line 203: ,pay_element_types_f pet

199: ,pec.classification_name
200: ,piv.uom
201: FROM hr_organization_information hoi
202: ,pay_element_classifications pec
203: ,pay_element_types_f pet
204: ,pay_input_values_f piv
205: WHERE hoi.organization_id = p_bus_grp_id
206: AND hoi.org_information_context = 'SA_PAYSLIP_ELEMENTS'
207: AND hoi.org_information1 = pet.element_type_id

Line 1348: FROM pay_element_types_f et

1344: SELECT nvl(pettl.reporting_name,pettl.element_name) rep_name
1345: ,et.element_type_id element_type_id
1346: ,iv.input_value_id input_value_id
1347: ,iv.uom uom
1348: FROM pay_element_types_f et
1349: , pay_element_types_f_tl pettl
1350: , pay_input_values_f iv
1351: , pay_element_classifications classification
1352: WHERE et.element_type_id = iv.element_type_id

Line 1349: , pay_element_types_f_tl pettl

1345: ,et.element_type_id element_type_id
1346: ,iv.input_value_id input_value_id
1347: ,iv.uom uom
1348: FROM pay_element_types_f et
1349: , pay_element_types_f_tl pettl
1350: , pay_input_values_f iv
1351: , pay_element_classifications classification
1352: WHERE et.element_type_id = iv.element_type_id
1353: AND et.element_type_id = pettl.element_type_id

Line 1375: FROM pay_element_types_f et

1371: SELECT nvl(pettl.reporting_name,pettl.element_name) rep_name
1372: ,et.element_type_id element_type_id
1373: ,iv.input_value_id input_value_id
1374: ,iv.uom uom
1375: FROM pay_element_types_f et
1376: , pay_element_types_f_tl pettl
1377: , pay_input_values_f iv
1378: , pay_element_classifications classification
1379: WHERE et.element_type_id = iv.element_type_id

Line 1376: , pay_element_types_f_tl pettl

1372: ,et.element_type_id element_type_id
1373: ,iv.input_value_id input_value_id
1374: ,iv.uom uom
1375: FROM pay_element_types_f et
1376: , pay_element_types_f_tl pettl
1377: , pay_input_values_f iv
1378: , pay_element_classifications classification
1379: WHERE et.element_type_id = iv.element_type_id
1380: AND et.element_type_id = pettl.element_type_id

Line 1885: ,pay_element_types_f pet

1881: ,ppa.payroll_id
1882: ,pap.business_group_id
1883: ,pap.accrual_plan_id
1884: FROM pay_accrual_plans pap
1885: ,pay_element_types_f pet
1886: ,pay_element_links_f pel
1887: ,pay_element_entries_f pee
1888: ,pay_assignment_actions paa
1889: ,pay_payroll_actions ppa

Line 2040: ,pay_element_types_f pet

2036: ,pec.classification_name
2037: ,piv.uom
2038: FROM hr_organization_information hoi
2039: ,pay_element_classifications pec
2040: ,pay_element_types_f pet
2041: ,pay_input_values_f piv
2042: WHERE hoi.organization_id = p_bus_grp_id
2043: AND hoi.org_information_context = 'SA_PAYSLIP_ELEMENTS'
2044: AND hoi.org_information1 = pet.element_type_id