APPS.PAY_AE_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: ,element_type VARCHAR2(1)
11: ,input_value_id pay_input_values_f.input_value_id%type
12: ,input_value VARCHAR2(60)

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: ,element_type VARCHAR2(1)
11: ,input_value_id pay_input_values_f.input_value_id%type
12: ,input_value VARCHAR2(60)
13: ,uom pay_input_values_f.uom%type

Line 211: ,pay_element_types_f pet

207: ,pec.classification_name
208: ,piv.uom
209: FROM hr_organization_information hoi
210: ,pay_element_classifications pec
211: ,pay_element_types_f pet
212: ,pay_input_values_f piv
213: WHERE hoi.organization_id = p_bus_grp_id
214: AND hoi.org_information_context = 'Business Group:Payslip Info'
215: AND hoi.org_information1 = 'ELEMENT'

Line 1323: FROM pay_element_types_f et

1319: SELECT nvl(pettl.reporting_name,pettl.element_name) rep_name
1320: ,et.element_type_id element_type_id
1321: ,iv.input_value_id input_value_id
1322: ,iv.uom uom
1323: FROM pay_element_types_f et
1324: , pay_element_types_f_tl pettl
1325: , pay_input_values_f iv
1326: , pay_element_classifications classification
1327: WHERE et.element_type_id = iv.element_type_id

Line 1324: , pay_element_types_f_tl pettl

1320: ,et.element_type_id element_type_id
1321: ,iv.input_value_id input_value_id
1322: ,iv.uom uom
1323: FROM pay_element_types_f et
1324: , pay_element_types_f_tl pettl
1325: , pay_input_values_f iv
1326: , pay_element_classifications classification
1327: WHERE et.element_type_id = iv.element_type_id
1328: AND et.element_type_id = pettl.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 1485: FROM pay_element_types_f et

1481: SELECT nvl(pettl.reporting_name,pettl.element_name) rep_name
1482: ,et.element_type_id element_type_id
1483: ,iv.input_value_id input_value_id
1484: ,iv.uom uom
1485: FROM pay_element_types_f et
1486: , pay_element_types_f_tl pettl
1487: , pay_input_values_f iv
1488: , pay_element_classifications classification
1489: WHERE et.element_type_id = iv.element_type_id

Line 1486: , pay_element_types_f_tl pettl

1482: ,et.element_type_id element_type_id
1483: ,iv.input_value_id input_value_id
1484: ,iv.uom uom
1485: FROM pay_element_types_f et
1486: , pay_element_types_f_tl pettl
1487: , pay_input_values_f iv
1488: , pay_element_classifications classification
1489: WHERE et.element_type_id = iv.element_type_id
1490: AND et.element_type_id = pettl.element_type_id

Line 1510: FROM pay_element_types_f et

1506: SELECT nvl(pettl.reporting_name,pettl.element_name) rep_name
1507: ,et.element_type_id element_type_id
1508: ,iv.input_value_id input_value_id
1509: ,iv.uom uom
1510: FROM pay_element_types_f et
1511: , pay_element_types_f_tl pettl
1512: , pay_input_values_f iv
1513: , pay_element_classifications classification
1514: WHERE et.element_type_id = iv.element_type_id

Line 1511: , pay_element_types_f_tl pettl

1507: ,et.element_type_id element_type_id
1508: ,iv.input_value_id input_value_id
1509: ,iv.uom uom
1510: FROM pay_element_types_f et
1511: , pay_element_types_f_tl pettl
1512: , pay_input_values_f iv
1513: , pay_element_classifications classification
1514: WHERE et.element_type_id = iv.element_type_id
1515: AND et.element_type_id = pettl.element_type_id

Line 1645: FROM pay_element_types_f_tl

1641: l_count_loan NUMBER := 0;
1642: BEGIN
1643: SELECT count(*)
1644: INTO l_count_loan
1645: FROM pay_element_types_f_tl
1646: WHERE element_type_id = csr_rec.element_type_id
1647: AND element_name = 'Loan Recovery'
1648: AND language = 'US';
1649: IF l_count_loan = 1 THEN

Line 2019: ,pay_element_types_f pet

2015: ,piv.uom
2016: ,piv.name input_value
2017: FROM hr_organization_information hoi
2018: ,pay_element_classifications pec
2019: ,pay_element_types_f pet
2020: ,pay_input_values_f piv
2021: WHERE hoi.organization_id = p_bus_grp_id
2022: AND hoi.org_information_context = 'Business Group:Payslip Info'
2023: AND hoi.org_information1 = 'ELEMENT'