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_NL_WAGE_REPORT_PKG dependencies on PAY_ASSIGNMENT_ACTIONS_S

Line 7522: SELECT pay_assignment_actions_s.NEXTVAL

7518: IF csr_persons_rec.person_id <> l_chk_person_id THEN
7519: --
7520: l_chk_person_id := csr_persons_rec.person_id;
7521: --
7522: SELECT pay_assignment_actions_s.NEXTVAL
7523: INTO l_actid
7524: FROM dual;
7525: -- CREATE THE ARCHIVE ASSIGNMENT ACTION
7526: hr_nonrun_asact.insact(lockingactid => l_actid

Line 7541: SELECT pay_assignment_actions_s.NEXTVAL

7537: l_chk_assignment_id := 0;
7538: FOR csr_rec IN csr_assignments_yearly(stperson,endperson,l_start_date,l_end_date,l_business_group_id,l_payroll_type,l_legal_employer,l_paid_flag) LOOP
7539: IF csr_rec.assignment_id <> l_chk_assignment_id THEN
7540: l_chk_assignment_id := csr_rec.assignment_id;
7541: SELECT pay_assignment_actions_s.NEXTVAL
7542: INTO l_actid
7543: FROM dual;
7544: --Fnd_file.put_line(FND_FILE.LOG,'#######~~csr_rec.assignment_action_id :'||l_actid||','||csr_rec.assignment_action_id);
7545: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION

Line 7568: SELECT pay_assignment_actions_s.NEXTVAL

7564: IF csr_rec.assignment_id <> l_chk_assignment_id THEN
7565: l_chk_assignment_id := csr_rec.assignment_id;
7566:
7567: IF csr_rec.assignment_action_id IS NOT NULL THEN --10100628
7568: SELECT pay_assignment_actions_s.NEXTVAL
7569: INTO l_actid
7570: FROM dual;
7571: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION
7572: hr_nonrun_asact.insact(lockingactid => l_actid

Line 7592: SELECT pay_assignment_actions_s.NEXTVAL

7588: --
7589: FOR csr_rec IN csr_assignments(stperson,endperson,l_start_date,l_end_date,l_business_group_id,l_payroll_type,l_legal_employer,l_paid_flag) LOOP
7590: IF csr_rec.assignment_id <> l_chk_assignment_id THEN
7591: l_chk_assignment_id := csr_rec.assignment_id;
7592: SELECT pay_assignment_actions_s.NEXTVAL
7593: INTO l_actid
7594: FROM dual;
7595: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION
7596: hr_nonrun_asact.insact(lockingactid => l_actid

Line 7644: SELECT pay_assignment_actions_s.NEXTVAL

7640: l_arc_pactid := TO_NUMBER(get_parameters(p_actid,'REQUEST_ID'));
7641: --
7642: FOR csr_rec IN csr_assignment_actions(l_arc_pactid) LOOP
7643: --
7644: SELECT pay_assignment_actions_s.NEXTVAL
7645: INTO l_actid
7646: FROM dual;
7647: --
7648: hr_nonrun_asact.insact(lockingactid => l_actid