DBA Data[Home] [Help]

APPS.PAY_DK_ARCHIVE dependencies on PAY_ELEMENT_TYPES_F

Line 220: ,pay_element_types_f pet

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

Line 1425: FROM pay_element_types_f et

1421: SELECT code.org_information2||','||nvl(pettl.reporting_name,pettl.element_name) rep_name
1422: ,et.element_type_id element_type_id
1423: ,iv.input_value_id input_value_id
1424: ,iv.uom uom
1425: FROM pay_element_types_f et
1426: , pay_element_types_f_tl pettl
1427: , pay_input_values_f iv
1428: , pay_element_classifications classification
1429: ,hr_organization_information code

Line 1426: , pay_element_types_f_tl pettl

1422: ,et.element_type_id element_type_id
1423: ,iv.input_value_id input_value_id
1424: ,iv.uom uom
1425: FROM pay_element_types_f et
1426: , pay_element_types_f_tl pettl
1427: , pay_input_values_f iv
1428: , pay_element_classifications classification
1429: ,hr_organization_information code
1430: WHERE et.element_type_id = iv.element_type_id

Line 1456: FROM pay_element_types_f et

1452: SELECT code.org_information2||','||nvl(pettl.reporting_name,pettl.element_name) rep_name
1453: ,et.element_type_id element_type_id
1454: ,iv.input_value_id input_value_id
1455: ,iv.uom uom
1456: FROM pay_element_types_f et
1457: , pay_element_types_f_tl pettl
1458: , pay_input_values_f iv
1459: , pay_element_classifications classification
1460: ,hr_organization_information code

Line 1457: , pay_element_types_f_tl pettl

1453: ,et.element_type_id element_type_id
1454: ,iv.input_value_id input_value_id
1455: ,iv.uom uom
1456: FROM pay_element_types_f et
1457: , pay_element_types_f_tl pettl
1458: , pay_input_values_f iv
1459: , pay_element_classifications classification
1460: ,hr_organization_information code
1461: WHERE et.element_type_id = iv.element_type_id

Line 1884: ,pay_element_types_f pet

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

Line 2030: ,pay_element_types_f pet

2026: ,pec.classification_name
2027: ,piv.uom
2028: FROM hr_organization_information hoi
2029: ,pay_element_classifications pec
2030: ,pay_element_types_f pet
2031: ,pay_input_values_f piv
2032: WHERE hoi.organization_id = p_bus_grp_id
2033: AND hoi.org_information_context = 'Business Group:Payslip Info'
2034: AND hoi.org_information1 = 'ELEMENT'

Line 3102: ,pay_element_types_f et

3098: FROM per_all_assignments_f asg1
3099: ,per_all_assignments_f asg2
3100: ,per_all_people_f per
3101: ,pay_element_links_f el
3102: ,pay_element_types_f et
3103: ,pay_input_values_f iv1
3104: ,pay_element_entries_f ee
3105: ,pay_element_entry_values_f eev1
3106: WHERE asg1.assignment_id = p_assignment_id

Line 3130: ,pay_element_types_f et

3126: SELECT ee.effective_start_date
3127: ,eev1.screen_entry_value screen_entry_value
3128: FROM per_all_assignments_f asg1
3129: ,pay_element_links_f el
3130: ,pay_element_types_f et
3131: ,pay_input_values_f iv1
3132: ,pay_element_entries_f ee
3133: ,pay_element_entry_values_f eev1
3134: WHERE asg1.assignment_id = p_assignment_id

Line 3659: FROM pay_element_types_f et

3655: ,et.element_type_id element_type_id
3656: ,iv.input_value_id input_value_id
3657: ,iv.uom uom
3658: ,et.processing_priority processing_priority
3659: FROM pay_element_types_f et
3660: , pay_element_types_f_tl pettl
3661: , pay_input_values_f iv
3662: , pay_element_classifications classification
3663: WHERE et.element_type_id = iv.element_type_id

Line 3660: , pay_element_types_f_tl pettl

3656: ,iv.input_value_id input_value_id
3657: ,iv.uom uom
3658: ,et.processing_priority processing_priority
3659: FROM pay_element_types_f et
3660: , pay_element_types_f_tl pettl
3661: , pay_input_values_f iv
3662: , pay_element_classifications classification
3663: WHERE et.element_type_id = iv.element_type_id
3664: AND et.element_type_id = pettl.element_type_id

Line 3684: FROM pay_element_types_f et

3680: ,et.element_type_id element_type_id
3681: ,iv.input_value_id input_value_id
3682: ,iv.uom uom
3683: ,et.processing_priority processing_priority
3684: FROM pay_element_types_f et
3685: , pay_element_types_f_tl pettl
3686: , pay_input_values_f iv
3687: , pay_element_classifications classification
3688: WHERE et.element_type_id = iv.element_type_id

Line 3685: , pay_element_types_f_tl pettl

3681: ,iv.input_value_id input_value_id
3682: ,iv.uom uom
3683: ,et.processing_priority processing_priority
3684: FROM pay_element_types_f et
3685: , pay_element_types_f_tl pettl
3686: , pay_input_values_f iv
3687: , pay_element_classifications classification
3688: WHERE et.element_type_id = iv.element_type_id
3689: AND et.element_type_id = pettl.element_type_id