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_EMP_CONT dependencies on PER_ALL_ASSIGNMENTS_F

Line 140: cursor csr_lu_mu (l_assignment_id per_all_assignments_f.ASSIGNMENT_ID%type

136:
137: -- Cursor to get the Local Unit and Tax Municipality
138:
139: /*
140: cursor csr_lu_mu (l_assignment_id per_all_assignments_f.ASSIGNMENT_ID%type
141: ,l_assignment_action_id pay_assignment_actions.ASSIGNMENT_ACTION_ID %type
142: ,p_date_earned DATE ) is
143: select scl.segment2 local_unit_id
144: ,rr.jurisdiction_code tax_mun_id

Line 145: from per_all_assignments_f asg

141: ,l_assignment_action_id pay_assignment_actions.ASSIGNMENT_ACTION_ID %type
142: ,p_date_earned DATE ) is
143: select scl.segment2 local_unit_id
144: ,rr.jurisdiction_code tax_mun_id
145: from per_all_assignments_f asg
146: ,hr_soft_coding_keyflex scl
147: ,pay_run_results rr
148: ,pay_element_types_f pet
149: where asg.assignment_id = l_assignment_id

Line 160: cursor csr_lu_mu (l_assignment_id per_all_assignments_f.ASSIGNMENT_ID%type

156: and rr.ASSIGNMENT_ACTION_ID = l_assignment_action_id ;
157: */
158:
159: /* Bug Fix: 5042861 - Modified cursor csr_lu_mu for performance fix to remove MERGE JOIN CARTESIAN*/
160: cursor csr_lu_mu (l_assignment_id per_all_assignments_f.ASSIGNMENT_ID%type
161: ,l_assignment_action_id pay_assignment_actions.ASSIGNMENT_ACTION_ID %type
162: ,p_date_earned DATE
163: ,l_ele_type_id NUMBER ) is
164: SELECT scl.segment2 local_unit_id

Line 167: ,per_all_assignments_f asg

163: ,l_ele_type_id NUMBER ) is
164: SELECT scl.segment2 local_unit_id
165: ,rr.jurisdiction_code tax_mun_id
166: FROM pay_assignment_actions assact
167: ,per_all_assignments_f asg
168: ,hr_soft_coding_keyflex scl
169: ,pay_run_results rr
170: WHERE assact.assignment_action_id = l_assignment_action_id
171: AND assact.assignment_id = asg.assignment_id

Line 191: ,per_all_assignments_f asg

187:
188: SELECT scl.segment2 loc_unit , assact.tax_unit_id leg_emp
189: FROM pay_assignment_actions assact
190: ,pay_run_types_f prt
191: ,per_all_assignments_f asg
192: ,hr_soft_coding_keyflex scl
193: WHERE assact.PAYROLL_ACTION_ID = p_payroll_action_id
194: and prt.LEGISLATION_CODE = 'NO'
195: and prt.RUN_TYPE_NAME = 'Employer Contributions'