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_NO_EOY_ARCHIVE dependencies on PAY_ACTION_CONTEXTS

Line 1102: ,pay_action_contexts pac1

1098: ,DECODE(orginf2.org_information5,'Y', orginf2.org_information2,orginf1.org_information4) nace_code -- 2007/08 changes
1099: ,paa.assignment_id assg_id -- 2007/2008 Changes
1100: FROM pay_assignment_actions paa
1101: ,pay_payroll_actions ppa
1102: ,pay_action_contexts pac1
1103: ,pay_action_contexts pac2
1104: ,ff_contexts ctx1
1105: ,ff_contexts ctx2
1106: ,hr_lookups lu

Line 1103: ,pay_action_contexts pac2

1099: ,paa.assignment_id assg_id -- 2007/2008 Changes
1100: FROM pay_assignment_actions paa
1101: ,pay_payroll_actions ppa
1102: ,pay_action_contexts pac1
1103: ,pay_action_contexts pac2
1104: ,ff_contexts ctx1
1105: ,ff_contexts ctx2
1106: ,hr_lookups lu
1107: ,hr_organization_information orginf1

Line 1636: ,pay_action_contexts ac1

1632: FROM per_all_assignments_f asg
1633: ,pay_assignment_actions paa
1634: ,pay_payroll_actions ppa
1635: ,pay_action_information ai
1636: ,pay_action_contexts ac1
1637: ,ff_contexts ctx1
1638: ,pay_action_contexts ac2
1639: ,ff_contexts ctx2
1640: ,pay_action_contexts ac3

Line 1638: ,pay_action_contexts ac2

1634: ,pay_payroll_actions ppa
1635: ,pay_action_information ai
1636: ,pay_action_contexts ac1
1637: ,ff_contexts ctx1
1638: ,pay_action_contexts ac2
1639: ,ff_contexts ctx2
1640: ,pay_action_contexts ac3
1641: ,ff_contexts ctx3
1642: ,pay_user_tables t

Line 1640: ,pay_action_contexts ac3

1636: ,pay_action_contexts ac1
1637: ,ff_contexts ctx1
1638: ,pay_action_contexts ac2
1639: ,ff_contexts ctx2
1640: ,pay_action_contexts ac3
1641: ,ff_contexts ctx3
1642: ,pay_user_tables t
1643: ,pay_user_rows_f r
1644: WHERE asg.person_id BETWEEN p_start_person AND p_end_person

Line 1929: ,pay_action_contexts ac1

1925: FROM pay_action_information cde_dtl
1926: ,pay_action_information cde_info_dtl
1927: ,pay_element_type_extra_info eei
1928: ,pay_assignment_actions paa
1929: ,pay_action_contexts ac1
1930: ,ff_contexts ctx1
1931: ,pay_action_contexts ac2
1932: ,ff_contexts ctx2
1933: ,pay_payroll_actions ppa

Line 1931: ,pay_action_contexts ac2

1927: ,pay_element_type_extra_info eei
1928: ,pay_assignment_actions paa
1929: ,pay_action_contexts ac1
1930: ,ff_contexts ctx1
1931: ,pay_action_contexts ac2
1932: ,ff_contexts ctx2
1933: ,pay_payroll_actions ppa
1934: ,pay_run_results rr
1935: ,pay_run_result_values rrv

Line 2045: ,pay_action_contexts ac1

2041: ,l_element_name IN VARCHAR2 ) IS
2042: SELECT rrv.result_value value
2043: ,pivf.uom dtype
2044: FROM pay_assignment_actions paa
2045: ,pay_action_contexts ac1
2046: ,ff_contexts ctx1
2047: ,pay_action_contexts ac2
2048: ,ff_contexts ctx2
2049: ,pay_payroll_actions ppa

Line 2047: ,pay_action_contexts ac2

2043: ,pivf.uom dtype
2044: FROM pay_assignment_actions paa
2045: ,pay_action_contexts ac1
2046: ,ff_contexts ctx1
2047: ,pay_action_contexts ac2
2048: ,ff_contexts ctx2
2049: ,pay_payroll_actions ppa
2050: ,pay_run_results rr
2051: ,pay_run_result_values rrv

Line 2106: ,pay_action_contexts ac1

2102: ,rr.run_result_id rr_id
2103: ,petf.element_name element_name
2104: ,ppa.action_type action_type
2105: FROM pay_assignment_actions paa
2106: ,pay_action_contexts ac1
2107: ,ff_contexts ctx1
2108: ,pay_action_contexts ac2
2109: ,ff_contexts ctx2
2110: ,pay_payroll_actions ppa

Line 2108: ,pay_action_contexts ac2

2104: ,ppa.action_type action_type
2105: FROM pay_assignment_actions paa
2106: ,pay_action_contexts ac1
2107: ,ff_contexts ctx1
2108: ,pay_action_contexts ac2
2109: ,ff_contexts ctx2
2110: ,pay_payroll_actions ppa
2111: ,pay_run_results rr
2112: ,pay_run_result_values rrv