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 230: ,pay_assignment_actions paa

226: --Cursor for fetching PT Org Id
227: CURSOR csr_get_pt_org is
228: SELECT hsc.segment3
229: FROM pay_element_entries_f target
230: ,pay_assignment_actions paa
231: ,pay_payroll_actions ppa
232: ,per_assignments_f paf
233: ,hr_soft_coding_keyflex hsc
234: WHERE ppa.payroll_action_id = paa.payroll_action_id

Line 249: ,pay_assignment_actions paa

245: --Cursor for fetching fact/Establishment Org Id
246: CURSOR csr_get_lwf_org is
247: SELECT nvl(hsc.segment6,hsc.segment5)
248: FROM pay_element_entries_f target
249: ,pay_assignment_actions paa
250: ,pay_payroll_actions ppa
251: ,per_assignments_f paf
252: ,hr_soft_coding_keyflex hsc
253: WHERE ppa.payroll_action_id = paa.payroll_action_id