APPS.PAY_NO_PAYSLIP_ARCHIVE dependencies on PAY_ELEMENT_TYPES_F

Line 250: ,pay_element_types_f pet

246: ,pec.classification_name ele_class
247: ,piv.uom uom
248: FROM hr_organization_information hoi
249: ,pay_element_classifications pec
250: ,pay_element_types_f pet
251: ,pay_input_values_f piv
252: WHERE hoi.organization_id = p_bus_grp_id
253: AND hoi.org_information_context = 'Business Group:Payslip Info'
254: AND hoi.org_information1 = 'ELEMENT'

Line 271: ,pay_element_types_f pet

267: ,piv.lookup_type lookup_type
268: ,piv.value_set_id value_set_id
269: FROM hr_organization_information hoi
270: ,pay_element_classifications pec
271: ,pay_element_types_f pet
272: ,pay_input_values_f piv
273: WHERE hoi.organization_id = p_bus_grp_id
274: AND hoi.org_information_context = 'Business Group:Payslip Info'
275: AND hoi.org_information1 = 'ELEMENT'

Line 1881: FROM pay_element_types_f et

1877: SELECT nvl(pettl.reporting_name,pettl.element_name) rep_name
1878: ,et.element_type_id element_type_id
1879: ,iv.input_value_id input_value_id
1880: ,iv.uom uom
1881: FROM pay_element_types_f et
1882: , pay_element_types_f_tl pettl
1883: , pay_input_values_f iv
1884: , pay_element_classifications classification
1885: WHERE et.element_type_id = iv.element_type_id

Line 1882: , pay_element_types_f_tl pettl

1878: ,et.element_type_id element_type_id
1879: ,iv.input_value_id input_value_id
1880: ,iv.uom uom
1881: FROM pay_element_types_f et
1882: , pay_element_types_f_tl pettl
1883: , pay_input_values_f iv
1884: , pay_element_classifications classification
1885: WHERE et.element_type_id = iv.element_type_id
1886: AND et.element_type_id = pettl.element_type_id

Line 1908: FROM pay_element_types_f et

1904: SELECT nvl(pettl.reporting_name,pettl.element_name) rep_name
1905: ,et.element_type_id element_type_id
1906: ,iv.input_value_id input_value_id
1907: ,iv.uom uom
1908: FROM pay_element_types_f et
1909: , pay_element_types_f_tl pettl
1910: , pay_input_values_f iv
1911: , pay_element_classifications classification
1912: WHERE et.element_type_id = iv.element_type_id

Line 1909: , pay_element_types_f_tl pettl

1905: ,et.element_type_id element_type_id
1906: ,iv.input_value_id input_value_id
1907: ,iv.uom uom
1908: FROM pay_element_types_f et
1909: , pay_element_types_f_tl pettl
1910: , pay_input_values_f iv
1911: , pay_element_classifications classification
1912: WHERE et.element_type_id = iv.element_type_id
1913: AND et.element_type_id = pettl.element_type_id

Line 1936: FROM pay_element_types_f et

1932: ,et.element_type_id element_type_id
1933: ,iv.input_value_id input_value_id
1934: ,iv.uom uom
1935: ,classification.classification_name ele_class
1936: FROM pay_element_types_f et
1937: , pay_element_types_f_tl pettl
1938: , pay_input_values_f iv
1939: , pay_element_classifications classification
1940: WHERE et.element_type_id = iv.element_type_id

Line 1937: , pay_element_types_f_tl pettl

1933: ,iv.input_value_id input_value_id
1934: ,iv.uom uom
1935: ,classification.classification_name ele_class
1936: FROM pay_element_types_f et
1937: , pay_element_types_f_tl pettl
1938: , pay_input_values_f iv
1939: , pay_element_classifications classification
1940: WHERE et.element_type_id = iv.element_type_id
1941: AND et.element_type_id = pettl.element_type_id

Line 1967: FROM pay_element_types_f et

1963: ,et.element_type_id element_type_id
1964: ,iv.input_value_id input_value_id
1965: ,iv.uom uom
1966: ,classification.classification_name ele_class
1967: FROM pay_element_types_f et
1968: , pay_element_types_f_tl pettl
1969: , pay_input_values_f iv
1970: , pay_element_classifications classification
1971: WHERE et.element_type_id = iv.element_type_id

Line 1968: , pay_element_types_f_tl pettl

1964: ,iv.input_value_id input_value_id
1965: ,iv.uom uom
1966: ,classification.classification_name ele_class
1967: FROM pay_element_types_f et
1968: , pay_element_types_f_tl pettl
1969: , pay_input_values_f iv
1970: , pay_element_classifications classification
1971: WHERE et.element_type_id = iv.element_type_id
1972: AND et.element_type_id = pettl.element_type_id

Line 2812: ,pay_element_types_f pet

2808: ,ppa.payroll_id
2809: ,pap.business_group_id
2810: ,pap.accrual_plan_id
2811: FROM pay_accrual_plans pap
2812: ,pay_element_types_f pet
2813: ,pay_element_links_f pel
2814: ,pay_element_entries_f pee
2815: ,pay_assignment_actions paa
2816: ,pay_payroll_actions ppa

Line 2960: ,pay_element_types_f pet

2956: ,pec.classification_name
2957: ,piv.uom
2958: FROM hr_organization_information hoi
2959: ,pay_element_classifications pec
2960: ,pay_element_types_f pet
2961: ,pay_input_values_f piv
2962: WHERE hoi.organization_id = p_bus_grp_id
2963: AND hoi.org_information_context = 'Business Group:Payslip Info'
2964: AND hoi.org_information1 = 'ELEMENT'

Line 3855: ,pay_element_types_f et

3851: FROM per_all_assignments_f asg1
3852: ,per_all_assignments_f asg2
3853: ,per_all_people_f per
3854: ,pay_element_links_f el
3855: ,pay_element_types_f et
3856: ,pay_input_values_f iv1
3857: ,pay_element_entries_f ee
3858: ,pay_element_entry_values_f eev1
3859: WHERE asg1.assignment_id = p_assignment_id

Line 3883: ,pay_element_types_f et

3879: SELECT ee.effective_start_date
3880: ,eev1.screen_entry_value screen_entry_value
3881: FROM per_all_assignments_f asg1
3882: ,pay_element_links_f el
3883: ,pay_element_types_f et
3884: ,pay_input_values_f iv1
3885: ,pay_element_entries_f ee
3886: ,pay_element_entry_values_f eev1
3887: WHERE asg1.assignment_id = p_assignment_id

Line 4216: FROM pay_element_types_f et

4212: SELECT nvl(pettl.reporting_name,pettl.element_name) rep_name
4213: ,et.element_type_id element_type_id
4214: ,iv.input_value_id input_value_id
4215: ,iv.uom uom
4216: FROM pay_element_types_f et
4217: , pay_element_types_f_tl pettl
4218: , pay_input_values_f iv
4219: , pay_element_classifications classification
4220: WHERE et.element_type_id = iv.element_type_id

Line 4217: , pay_element_types_f_tl pettl

4213: ,et.element_type_id element_type_id
4214: ,iv.input_value_id input_value_id
4215: ,iv.uom uom
4216: FROM pay_element_types_f et
4217: , pay_element_types_f_tl pettl
4218: , pay_input_values_f iv
4219: , pay_element_classifications classification
4220: WHERE et.element_type_id = iv.element_type_id
4221: AND et.element_type_id = pettl.element_type_id

Line 4243: FROM pay_element_types_f et

4239: SELECT nvl(pettl.reporting_name,pettl.element_name) rep_name
4240: ,et.element_type_id element_type_id
4241: ,iv.input_value_id input_value_id
4242: ,iv.uom uom
4243: FROM pay_element_types_f et
4244: , pay_element_types_f_tl pettl
4245: , pay_input_values_f iv
4246: , pay_element_classifications classification
4247: WHERE et.element_type_id = iv.element_type_id

Line 4244: , pay_element_types_f_tl pettl

4240: ,et.element_type_id element_type_id
4241: ,iv.input_value_id input_value_id
4242: ,iv.uom uom
4243: FROM pay_element_types_f et
4244: , pay_element_types_f_tl pettl
4245: , pay_input_values_f iv
4246: , pay_element_classifications classification
4247: WHERE et.element_type_id = iv.element_type_id
4248: AND et.element_type_id = pettl.element_type_id

Line 4353: FROM pay_element_types_f

4349: /* cursor to get the element type id for 'Tax' element */
4350: /*
4351: CURSOR csr_get_tax_element IS
4352: SELECT element_type_id
4353: FROM pay_element_types_f
4354: WHERE element_name = 'Tax'
4355: AND legislation_code = 'NO'
4356: AND business_group_id IS NULL
4357: AND p_date_earned BETWEEN effective_start_date AND effective_end_date ;

Line 4366: from pay_element_types_f

4362: -- cursor to get the name of the element
4363:
4364: cursor csr_element_name (p_element_type_id NUMBER) IS
4365: select element_name
4366: from pay_element_types_f
4367: where element_type_id = p_element_type_id
4368: and p_date_earned between effective_start_date and effective_end_date ;
4369:
4370: -----------------------------------------

Line 4398: ,pay_element_types_f et

4394: CURSOR csr_tax_period_override (p_assignment_id NUMBER, p_input_value VARCHAR2) IS
4395: SELECT eev1.screen_entry_value screen_entry_value
4396: FROM per_all_assignments_f asg1
4397: ,pay_element_links_f el
4398: ,pay_element_types_f et
4399: ,pay_input_values_f iv1
4400: ,pay_element_entries_f ee
4401: ,pay_element_entry_values_f eev1
4402: WHERE asg1.assignment_id = p_assignment_id