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_IN_RULES dependencies on PAY_ASSIGNMENT_ACTIONS

Line 77: ,pay_assignment_actions paa

73: --Cursor for fetching PF Org Id
74: CURSOR csr_get_pf_source IS
75: SELECT hsc.segment2
76: FROM pay_element_entries_f target
77: ,pay_assignment_actions paa
78: ,pay_payroll_actions ppa
79: ,per_assignments_f paf
80: ,hr_soft_coding_keyflex hsc
81: WHERE ppa.payroll_action_id = paa.payroll_action_id

Line 96: ,pay_assignment_actions paa

92: --Cursor for fetching PT Org Id
93: CURSOR csr_get_pt_source is
94: SELECT hsc.segment3
95: FROM pay_element_entries_f target
96: ,pay_assignment_actions paa
97: ,pay_payroll_actions ppa
98: ,per_assignments_f paf
99: ,hr_soft_coding_keyflex hsc
100: WHERE ppa.payroll_action_id = paa.payroll_action_id

Line 115: ,pay_assignment_actions paa

111: --Cursor for fetching ESI Org Id
112: CURSOR csr_get_esi_source IS
113: SELECT hsc.segment4
114: FROM pay_element_entries_f target
115: ,pay_assignment_actions paa
116: ,pay_payroll_actions ppa
117: ,per_assignments_f paf
118: ,hr_soft_coding_keyflex hsc
119: WHERE ppa.payroll_action_id = paa.payroll_action_id

Line 134: ,pay_assignment_actions paa

130: --Cursor for fetching fact/Establishment Org Id
131: CURSOR csr_get_lwf_org is
132: SELECT nvl(hsc.segment6,hsc.segment5)
133: FROM pay_element_entries_f target
134: ,pay_assignment_actions paa
135: ,pay_payroll_actions ppa
136: ,per_assignments_f paf
137: ,hr_soft_coding_keyflex hsc
138: WHERE ppa.payroll_action_id = paa.payroll_action_id

Line 238: ,pay_assignment_actions paa

234: --Cursor for fetching PT Org Id
235: CURSOR csr_get_pt_org is
236: SELECT hsc.segment3
237: FROM pay_element_entries_f target
238: ,pay_assignment_actions paa
239: ,pay_payroll_actions ppa
240: ,per_assignments_f paf
241: ,hr_soft_coding_keyflex hsc
242: WHERE ppa.payroll_action_id = paa.payroll_action_id

Line 257: ,pay_assignment_actions paa

253: --Cursor for fetching fact/Establishment Org Id
254: CURSOR csr_get_lwf_org is
255: SELECT nvl(hsc.segment6,hsc.segment5)
256: FROM pay_element_entries_f target
257: ,pay_assignment_actions paa
258: ,pay_payroll_actions ppa
259: ,per_assignments_f paf
260: ,hr_soft_coding_keyflex hsc
261: WHERE ppa.payroll_action_id = paa.payroll_action_id