eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_FI_ARCHIVE_PYSA dependencies on PAY_ELEMENT_TYPES_F

Line 181: ,pay_element_types_f pet

177: ,pec.classification_name
178: ,piv.uom
179: FROM hr_organization_information hoi
180: ,pay_element_classifications pec
181: ,pay_element_types_f pet
182: ,pay_input_values_f piv
183: WHERE hoi.organization_id = p_bus_grp_id
184: AND hoi.org_information_context = 'Business Group:Payslip Info'
185: AND hoi.org_information1 = 'ELEMENT'

Line 1070: FROM pay_element_types_f et

1066: SELECT nvl(pettl.reporting_name,pettl.element_name) rep_name
1067: ,et.element_type_id element_type_id
1068: ,iv.input_value_id input_value_id
1069: ,iv.uom uom
1070: FROM pay_element_types_f et
1071: , pay_element_types_f_tl pettl
1072: , pay_input_values_f iv
1073: , pay_element_classifications classification
1074: WHERE et.element_type_id = iv.element_type_id

Line 1071: , pay_element_types_f_tl pettl

1067: ,et.element_type_id element_type_id
1068: ,iv.input_value_id input_value_id
1069: ,iv.uom uom
1070: FROM pay_element_types_f et
1071: , pay_element_types_f_tl pettl
1072: , pay_input_values_f iv
1073: , pay_element_classifications classification
1074: WHERE et.element_type_id = iv.element_type_id
1075: AND et.element_type_id = pettl.element_type_id

Line 1102: FROM pay_element_types_f et

1098: SELECT nvl(pettl.reporting_name,pettl.element_name) rep_name
1099: ,et.element_type_id element_type_id
1100: ,iv.input_value_id input_value_id
1101: ,iv.uom uom
1102: FROM pay_element_types_f et
1103: , pay_element_types_f_tl pettl
1104: , pay_input_values_f iv
1105: , pay_element_classifications classification
1106: WHERE et.element_type_id = iv.element_type_id

Line 1103: , pay_element_types_f_tl pettl

1099: ,et.element_type_id element_type_id
1100: ,iv.input_value_id input_value_id
1101: ,iv.uom uom
1102: FROM pay_element_types_f et
1103: , pay_element_types_f_tl pettl
1104: , pay_input_values_f iv
1105: , pay_element_classifications classification
1106: WHERE et.element_type_id = iv.element_type_id
1107: AND et.element_type_id = pettl.element_type_id

Line 1454: ,pay_element_types_f pet

1450: ,ppa.payroll_id
1451: ,pap.business_group_id
1452: ,pap.accrual_plan_id
1453: FROM pay_accrual_plans pap
1454: ,pay_element_types_f pet
1455: ,pay_element_links_f pel
1456: ,pay_element_entries_f pee
1457: ,pay_assignment_actions paa
1458: ,pay_payroll_actions ppa

Line 1594: ,pay_element_types_f pet

1590: ,pec.classification_name
1591: ,piv.uom
1592: FROM hr_organization_information hoi
1593: ,pay_element_classifications pec
1594: ,pay_element_types_f pet
1595: ,pay_input_values_f piv
1596: WHERE hoi.organization_id = p_bus_grp_id
1597: AND hoi.org_information_context = 'Business Group:Payslip Info'
1598: AND hoi.org_information1 = 'ELEMENT'

Line 1818: ,pay_element_types_f et

1814: FROM per_all_assignments_f asg1
1815: ,per_all_assignments_f asg2
1816: ,per_all_people_f per
1817: ,pay_element_links_f el
1818: ,pay_element_types_f et
1819: ,pay_input_values_f iv1
1820: ,pay_element_entries_f ee
1821: ,pay_element_entry_values_f eev1
1822: WHERE asg1.assignment_id = p_assignment_id

Line 1846: ,pay_element_types_f et

1842: SELECT ee.effective_start_date
1843: ,eev1.screen_entry_value screen_entry_value
1844: FROM per_all_assignments_f asg1
1845: ,pay_element_links_f el
1846: ,pay_element_types_f et
1847: ,pay_input_values_f iv1
1848: ,pay_element_entries_f ee
1849: ,pay_element_entry_values_f eev1
1850: WHERE asg1.assignment_id = p_assignment_id

Line 2723: FROM pay_element_types_f et

2719: SELECT nvl(pettl.reporting_name,pettl.element_name) rep_name
2720: ,et.element_type_id element_type_id
2721: ,iv.input_value_id input_value_id
2722: ,iv.uom uom
2723: FROM pay_element_types_f et
2724: , pay_element_types_f_tl pettl
2725: , pay_input_values_f iv
2726: , pay_element_classifications classification
2727: WHERE et.element_type_id = iv.element_type_id

Line 2724: , pay_element_types_f_tl pettl

2720: ,et.element_type_id element_type_id
2721: ,iv.input_value_id input_value_id
2722: ,iv.uom uom
2723: FROM pay_element_types_f et
2724: , pay_element_types_f_tl pettl
2725: , pay_input_values_f iv
2726: , pay_element_classifications classification
2727: WHERE et.element_type_id = iv.element_type_id
2728: AND et.element_type_id = pettl.element_type_id

Line 2758: FROM pay_element_types_f et

2754: SELECT nvl(pettl.reporting_name,pettl.element_name) rep_name
2755: ,et.element_type_id element_type_id
2756: ,iv.input_value_id input_value_id
2757: ,iv.uom uom
2758: FROM pay_element_types_f et
2759: , pay_element_types_f_tl pettl
2760: , pay_input_values_f iv
2761: , pay_element_classifications classification
2762: WHERE et.element_type_id = iv.element_type_id

Line 2759: , pay_element_types_f_tl pettl

2755: ,et.element_type_id element_type_id
2756: ,iv.input_value_id input_value_id
2757: ,iv.uom uom
2758: FROM pay_element_types_f et
2759: , pay_element_types_f_tl pettl
2760: , pay_input_values_f iv
2761: , pay_element_classifications classification
2762: WHERE et.element_type_id = iv.element_type_id
2763: AND et.element_type_id = pettl.element_type_id