DBA Data[Home] [Help]

APPS.PAY_DK_ARCHIVE dependencies on PAY_ELEMENT_TYPES_F

Line 219: ,pay_element_types_f pet

215: ,pec.classification_name
216: ,piv.uom
217: FROM hr_organization_information hoi
218: ,pay_element_classifications pec
219: ,pay_element_types_f pet
220: ,pay_input_values_f piv
221: WHERE hoi.organization_id = p_bus_grp_id
222: AND hoi.org_information_context = 'Business Group:Payslip Info'
223: AND hoi.org_information1 = 'ELEMENT'

Line 1410: FROM pay_element_types_f et

1406: SELECT nvl(pettl.reporting_name,pettl.element_name) rep_name
1407: ,et.element_type_id element_type_id
1408: ,iv.input_value_id input_value_id
1409: ,iv.uom uom
1410: FROM pay_element_types_f et
1411: , pay_element_types_f_tl pettl
1412: , pay_input_values_f iv
1413: , pay_element_classifications classification
1414: WHERE et.element_type_id = iv.element_type_id

Line 1411: , pay_element_types_f_tl pettl

1407: ,et.element_type_id element_type_id
1408: ,iv.input_value_id input_value_id
1409: ,iv.uom uom
1410: FROM pay_element_types_f et
1411: , pay_element_types_f_tl pettl
1412: , pay_input_values_f iv
1413: , pay_element_classifications classification
1414: WHERE et.element_type_id = iv.element_type_id
1415: AND et.element_type_id = pettl.element_type_id

Line 1434: FROM pay_element_types_f et

1430: SELECT nvl(pettl.reporting_name,pettl.element_name) rep_name
1431: ,et.element_type_id element_type_id
1432: ,iv.input_value_id input_value_id
1433: ,iv.uom uom
1434: FROM pay_element_types_f et
1435: , pay_element_types_f_tl pettl
1436: , pay_input_values_f iv
1437: , pay_element_classifications classification
1438: WHERE et.element_type_id = iv.element_type_id

Line 1435: , pay_element_types_f_tl pettl

1431: ,et.element_type_id element_type_id
1432: ,iv.input_value_id input_value_id
1433: ,iv.uom uom
1434: FROM pay_element_types_f et
1435: , pay_element_types_f_tl pettl
1436: , pay_input_values_f iv
1437: , pay_element_classifications classification
1438: WHERE et.element_type_id = iv.element_type_id
1439: AND et.element_type_id = pettl.element_type_id

Line 1856: ,pay_element_types_f pet

1852: ,ppa.payroll_id
1853: ,pap.business_group_id
1854: ,pap.accrual_plan_id
1855: FROM pay_accrual_plans pap
1856: ,pay_element_types_f pet
1857: ,pay_element_links_f pel
1858: ,pay_element_entries_f pee
1859: ,pay_assignment_actions paa
1860: ,pay_payroll_actions ppa

Line 2002: ,pay_element_types_f pet

1998: ,pec.classification_name
1999: ,piv.uom
2000: FROM hr_organization_information hoi
2001: ,pay_element_classifications pec
2002: ,pay_element_types_f pet
2003: ,pay_input_values_f piv
2004: WHERE hoi.organization_id = p_bus_grp_id
2005: AND hoi.org_information_context = 'Business Group:Payslip Info'
2006: AND hoi.org_information1 = 'ELEMENT'

Line 2660: ,pay_element_types_f et

2656: FROM per_all_assignments_f asg1
2657: ,per_all_assignments_f asg2
2658: ,per_all_people_f per
2659: ,pay_element_links_f el
2660: ,pay_element_types_f et
2661: ,pay_input_values_f iv1
2662: ,pay_element_entries_f ee
2663: ,pay_element_entry_values_f eev1
2664: WHERE asg1.assignment_id = p_assignment_id

Line 2688: ,pay_element_types_f et

2684: SELECT ee.effective_start_date
2685: ,eev1.screen_entry_value screen_entry_value
2686: FROM per_all_assignments_f asg1
2687: ,pay_element_links_f el
2688: ,pay_element_types_f et
2689: ,pay_input_values_f iv1
2690: ,pay_element_entries_f ee
2691: ,pay_element_entry_values_f eev1
2692: WHERE asg1.assignment_id = p_assignment_id

Line 3186: FROM pay_element_types_f et

3182: ,et.element_type_id element_type_id
3183: ,iv.input_value_id input_value_id
3184: ,iv.uom uom
3185: ,et.processing_priority processing_priority
3186: FROM pay_element_types_f et
3187: , pay_element_types_f_tl pettl
3188: , pay_input_values_f iv
3189: , pay_element_classifications classification
3190: WHERE et.element_type_id = iv.element_type_id

Line 3187: , pay_element_types_f_tl pettl

3183: ,iv.input_value_id input_value_id
3184: ,iv.uom uom
3185: ,et.processing_priority processing_priority
3186: FROM pay_element_types_f et
3187: , pay_element_types_f_tl pettl
3188: , pay_input_values_f iv
3189: , pay_element_classifications classification
3190: WHERE et.element_type_id = iv.element_type_id
3191: AND et.element_type_id = pettl.element_type_id

Line 3211: FROM pay_element_types_f et

3207: ,et.element_type_id element_type_id
3208: ,iv.input_value_id input_value_id
3209: ,iv.uom uom
3210: ,et.processing_priority processing_priority
3211: FROM pay_element_types_f et
3212: , pay_element_types_f_tl pettl
3213: , pay_input_values_f iv
3214: , pay_element_classifications classification
3215: WHERE et.element_type_id = iv.element_type_id

Line 3212: , pay_element_types_f_tl pettl

3208: ,iv.input_value_id input_value_id
3209: ,iv.uom uom
3210: ,et.processing_priority processing_priority
3211: FROM pay_element_types_f et
3212: , pay_element_types_f_tl pettl
3213: , pay_input_values_f iv
3214: , pay_element_classifications classification
3215: WHERE et.element_type_id = iv.element_type_id
3216: AND et.element_type_id = pettl.element_type_id