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.PER_ES_COMP_CERT_ARCHIVE_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 188: ,pay_assignment_actions act

184: AND hoi.org_information_context = 'ES_WORK_CENTER_REF'
185: AND hoi.organization_id = decode(c_legal_employer,NULL,hoi.organization_id,c_legal_employer)
186: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
187: FROM pay_payroll_actions appa
188: ,pay_assignment_actions act
189: ,pay_action_information pai
190: WHERE act.assignment_id = asl.assignment_id
191: AND act.payroll_action_id = appa.payroll_action_id
192: AND appa.report_category = 'ARCHIVE'

Line 231: ,pay_assignment_actions act

227: AND hoi.organization_id =NVL(c_legal_employer,hoi.organization_id)
228: AND c_end_date between asl.effective_start_date and asl.effective_end_date
229: AND NOT EXISTS (SELECT NULL
230: FROM pay_payroll_actions appa
231: ,pay_assignment_actions act
232: ,pay_action_information pai
233: WHERE act.assignment_id = asl.assignment_id
234: AND act.payroll_action_id = appa.payroll_action_id
235: AND appa.report_category = 'ARCHIVE'

Line 245: ,pay_assignment_actions act

241: AND pai.action_information21 = 'S'
242: AND pai.action_information22 = to_char(paa.absence_attendance_id))
243: AND NOT EXISTS (SELECT NULL
244: FROM pay_payroll_actions appa
245: ,pay_assignment_actions act
246: WHERE appa.payroll_action_id = c_p_actid
247: AND act.payroll_action_id = appa.payroll_action_id
248: AND act.assignment_id = asl.assignment_id);
249: --

Line 271: SELECT pay_assignment_actions_s.NEXTVAL

267: ,l_start_date
268: ,l_end_date
269: ,l_business_group_id) LOOP
270: --
271: SELECT pay_assignment_actions_s.NEXTVAL
272: INTO l_actid
273: FROM dual;
274: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION
275: hr_nonrun_asact.insact(l_actid,csr_rec.assignment_id,p_actid,chunk,NULL);

Line 286: SELECT pay_assignment_actions_s.NEXTVAL

282: ,l_start_date
283: ,l_end_date
284: ,l_business_group_id) LOOP
285: --
286: SELECT pay_assignment_actions_s.NEXTVAL
287: INTO l_actid
288: FROM dual;
289: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION
290: hr_nonrun_asact.insact(l_actid,csr_rec.assignment_id,p_actid,chunk,NULL);

Line 475: ,pay_assignment_actions paas

471: ,fnd_date.canonical_to_date(pps.pds_information10) vacation_to
472: FROM per_all_people_f pap
473: ,per_all_assignments_f paa
474: ,per_periods_of_service pps
475: ,pay_assignment_actions paas
476: ,pay_payroll_actions ppa
477: ,hr_soft_coding_keyflex hr
478: ,hr_organization_information hoi
479: WHERE paas.assignment_action_id = p_assactid

Line 522: ,pay_assignment_actions paas

518: ,fnd_date.canonical_to_date(pps.pds_information9) vacation_from
519: ,fnd_date.canonical_to_date(pps.pds_information10) vacation_to
520: FROM per_all_people_f pap
521: ,per_all_assignments_f paa
522: ,pay_assignment_actions paas
523: ,pay_payroll_actions ppa
524: ,per_periods_of_service pps
525: ,hr_soft_coding_keyflex hr
526: ,hr_organization_information hoi

Line 1046: ,pay_assignment_actions paa

1042: ,substr(pai4.action_information10,1,13) eprov_name
1043: ,substr(pai4.action_information12,1,6) epostal_code
1044: ,paa.assignment_action_id
1045: FROM pay_payroll_actions ppa
1046: ,pay_assignment_actions paa
1047: ,pay_action_information pai1 --Employer rec
1048: ,pay_action_information pai2 --Employer Address
1049: ,pay_action_information pai3 --Employee rec
1050: ,pay_action_information pai4 --Employee address