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

Line 119: pay_assignment_actions act,

115: sqlstr :=
116: 'SELECT distinct asg.person_id
117: FROM pay_payroll_actions ppa,
118: pay_payroll_actions pa1,
119: pay_assignment_actions act,
120: per_assignments_f asg,
121: pay_payrolls_f ppf
122: WHERE ppa.payroll_action_id = :payroll_action_id
123: '||l_consolidation_set_text||'

Line 196: pay_assignment_actions act,

192: nvl(ppa.start_date,ppa.effective_date)
193: FROM pay_payrolls_f ppf,
194: pay_payroll_actions ppa, /* pre-payments and reversals
195: payroll action id */
196: pay_assignment_actions act,
197: per_assignments_f paf
198: WHERE (c_payroll_id is NULL
199: OR ppa.payroll_id = c_payroll_id)
200: AND ppa.consolidation_set_id +0 = nvl(c_consolidation_set_id,

Line 252: pay_assignment_actions act ,

248: act.source_action_id,
249: nvl(ppa.start_date,ppa.effective_date)
250: FROM hr_assignment_set_amendments hasa ,
251: per_assignments_f paf ,
252: pay_assignment_actions act ,
253: pay_payroll_actions ppa ,
254: pay_payrolls_f ppf
255: WHERE (c_payroll_id IS NULL
256: OR ppa.payroll_id = c_payroll_id)

Line 310: pay_assignment_actions paa,

306: CURSOR c_run_eff_date (cp_pre_pymt_action_id IN NUMBER) IS
307: SELECT ppa.effective_date,
308: ppa.action_type
309: FROM pay_action_interlocks pai,
310: pay_assignment_actions paa,
311: pay_payroll_actions ppa
312: WHERE pai.locking_action_id = cp_pre_pymt_action_id
313: AND paa.assignment_action_id = pai.locked_action_id
314: AND ppa.payroll_action_id = paa.payroll_action_id

Line 320: pay_assignment_actions paa,

316:
317: CURSOR c_payroll_run (cp_pre_pymt_action_id IN NUMBER) IS
318: SELECT assignment_action_id, ppa.action_type
319: FROM pay_action_interlocks pai,
320: pay_assignment_actions paa,
321: pay_payroll_actions ppa
322: WHERE pai.locking_action_id = cp_pre_pymt_action_id
323: AND paa.assignment_action_id = pai.locked_action_id
324: AND ppa.payroll_action_id = paa.payroll_action_id

Line 341: pay_assignment_actions paa,

337:
338: CURSOR c_multi_ba_acts(cp_pre_pymt_action_id IN NUMBER) IS
339: SELECT assignment_action_id, ppa.action_type
340: FROM pay_action_interlocks pai,
341: pay_assignment_actions paa,
342: pay_payroll_actions ppa
343: WHERE pai.locking_action_id = cp_pre_pymt_action_id
344: AND paa.assignment_action_id = pai.locked_action_id
345: AND ppa.payroll_action_id = paa.payroll_action_id

Line 381: FROM pay_assignment_actions paa2, -- assignment_actions for slave payroll runs.

377:
378:
379: CURSOR c_multi_asg_acts (cp_pre_pymt_action_id IN NUMBER) IS
380: SELECT max(paa2.assignment_action_id)
381: FROM pay_assignment_actions paa2, -- assignment_actions for slave payroll runs.
382: pay_assignment_actions paa1, -- assignment_action for master payroll run
383: pay_run_Types_f prt,
384: pay_payroll_actions ppa,
385: pay_action_interlocks pai

Line 382: pay_assignment_actions paa1, -- assignment_action for master payroll run

378:
379: CURSOR c_multi_asg_acts (cp_pre_pymt_action_id IN NUMBER) IS
380: SELECT max(paa2.assignment_action_id)
381: FROM pay_assignment_actions paa2, -- assignment_actions for slave payroll runs.
382: pay_assignment_actions paa1, -- assignment_action for master payroll run
383: pay_run_Types_f prt,
384: pay_payroll_actions ppa,
385: pay_action_interlocks pai
386: WHERE pai.locking_action_id = cp_pre_pymt_action_id

Line 407: FROM pay_assignment_actions paa2,

403: -- to only return the specific tu assignment actions.
404:
405: CURSOR c_multi_asg_rpt_acts (cp_pre_pymt_action_id IN NUMBER) IS
406: SELECT DISTINCT max(paa2.assignment_action_id)
407: FROM pay_assignment_actions paa2,
408: -- assignment_actions for slave payroll runs.
409: pay_assignment_actions paa1,
410: -- assignment_action for master payroll run
411: pay_run_Types_f prt,

Line 409: pay_assignment_actions paa1,

405: CURSOR c_multi_asg_rpt_acts (cp_pre_pymt_action_id IN NUMBER) IS
406: SELECT DISTINCT max(paa2.assignment_action_id)
407: FROM pay_assignment_actions paa2,
408: -- assignment_actions for slave payroll runs.
409: pay_assignment_actions paa1,
410: -- assignment_action for master payroll run
411: pay_run_Types_f prt,
412: pay_payroll_actions ppa,
413: pay_action_interlocks pai

Line 430: pay_assignment_actions paa,

426:
427: CURSOR c_check_for_void (cp_pre_pymt_action_id IN NUMBER) IS
428: SELECT 'Y'
429: FROM pay_action_interlocks pai,
430: pay_assignment_actions paa,
431: pay_payroll_actions ppa
432: WHERE pai.locking_action_id = cp_pre_pymt_action_id
433: AND paa.assignment_action_id = pai.locked_action_id
434: AND ppa.payroll_action_id = paa.payroll_action_id

Line 439: FROM pay_assignment_actions

435: AND action_type = 'V';
436:
437: CURSOR c_check_for_assig_act (cp_assig_id IN NUMBER) IS
438: SELECT assignment_action_id
439: FROM pay_assignment_actions
440: WHERE assignment_id = cp_assig_id
441: AND payroll_action_id = pactid;
442:
443: lockingactid NUMBER;

Line 472: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;

468: l_void_action VARCHAR2(1);
469: l_payroll_id pay_payroll_actions.payroll_id%TYPE;
470: l_location_id per_all_assignments_f.location_id%TYPE;
471: l_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE;
472: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
473: l_person_id per_all_assignments_f.person_id%TYPE;
474: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
475: l_organization_id per_all_assignments_f.organization_id%TYPE;
476: l_assignment_set_id hr_assignment_set_amendments.assignment_set_id%TYPE;

Line 650: SELECT pay_assignment_actions_s.nextval

646: FETCH c_payment_info INTO ln_source_action_id;
647: EXIT WHEN c_payment_info%NOTFOUND;
648: IF ln_source_action_id = -999 THEN
649: hr_utility.set_location(l_proc_name,120);
650: SELECT pay_assignment_actions_s.nextval
651: INTO lockingactid
652: FROM dual;
653: hr_utility.set_location(l_proc_name,125);
654: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);

Line 665: -- update pay_assignment_actions serial_number with runactid.

661: FETCH c_payroll_run INTO ln_master_action_id,lv_run_action_type;
662: CLOSE c_payroll_run;
663:
664: serialno := lv_run_action_type || to_char(ln_master_action_id);
665: -- update pay_assignment_actions serial_number with runactid.
666: UPDATE pay_assignment_actions
667: SET serial_number = serialno
668: WHERE assignment_action_id = lockingactid
669: AND tax_unit_id = greid;

Line 666: UPDATE pay_assignment_actions

662: CLOSE c_payroll_run;
663:
664: serialno := lv_run_action_type || to_char(ln_master_action_id);
665: -- update pay_assignment_actions serial_number with runactid.
666: UPDATE pay_assignment_actions
667: SET serial_number = serialno
668: WHERE assignment_action_id = lockingactid
669: AND tax_unit_id = greid;
670: hr_utility.set_location(l_proc_name,140);

Line 692: SELECT pay_assignment_actions_s.nextval

688: hr_utility.set_location(l_proc_name,145);
689: ELSIF ln_source_action_id <> -999 THEN
690: hr_utility.set_location(l_proc_name,150);
691: -- #16364431 Start
692: SELECT pay_assignment_actions_s.nextval
693: INTO lockingactid
694: FROM dual;
695: hr_utility.set_location(l_proc_name,152);
696:

Line 709: -- update pay_assignment_actions serial_number with runactid.

705: hr_nonrun_asact.insint(lockingactid,lockedactid);
706:
707: hr_utility.set_location(l_proc_name,155);
708: serialno := actiontype || to_char(ln_source_action_id);
709: -- update pay_assignment_actions serial_number with runactid.
710: UPDATE pay_assignment_actions
711: SET serial_number = serialno
712: WHERE assignment_action_id = lockingactid
713: AND tax_unit_id = greid;

Line 710: UPDATE pay_assignment_actions

706:
707: hr_utility.set_location(l_proc_name,155);
708: serialno := actiontype || to_char(ln_source_action_id);
709: -- update pay_assignment_actions serial_number with runactid.
710: UPDATE pay_assignment_actions
711: SET serial_number = serialno
712: WHERE assignment_action_id = lockingactid
713: AND tax_unit_id = greid;
714: runactid := ln_source_action_id;

Line 739: SELECT pay_assignment_actions_s.nextval

735: END LOOP;
736: CLOSE c_payment_info;
737: ELSE -- This is a void action.
738: hr_utility.set_location(l_proc_name,175);
739: SELECT pay_assignment_actions_s.nextval
740: INTO lockingactid
741: FROM dual;
742: hr_utility.set_location(l_proc_name,180);
743: -- insert the action record.

Line 754: -- update pay_assignment_actions serial_number with runactid.

750:
751: BEGIN
752: hr_utility.set_location(l_proc_name,205);
753: serialno := actiontype || to_char(lockedactid);
754: -- update pay_assignment_actions serial_number with runactid.
755: UPDATE pay_assignment_actions
756: SET serial_number = serialno
757: WHERE assignment_action_id = lockingactid
758: AND tax_unit_id = greid;

Line 755: UPDATE pay_assignment_actions

751: BEGIN
752: hr_utility.set_location(l_proc_name,205);
753: serialno := actiontype || to_char(lockedactid);
754: -- update pay_assignment_actions serial_number with runactid.
755: UPDATE pay_assignment_actions
756: SET serial_number = serialno
757: WHERE assignment_action_id = lockingactid
758: AND tax_unit_id = greid;
759: EXCEPTION

Line 1004: ,pay_assignment_actions paa

1000: CURSOR c_get_payroll_period (asg_action_id NUMBER) is
1001: SELECT ptp.start_date
1002: ,ptp.end_date
1003: FROM pay_payroll_actions ppa
1004: ,pay_assignment_actions paa
1005: ,per_time_periods ptp
1006: WHERE ppa.payroll_action_id = paa.payroll_action_id
1007: AND ptp.time_period_id = ppa.time_period_id
1008: AND paa.assignment_action_id = asg_action_id;

Line 1014: ,pay_assignment_actions paa

1010: CURSOR c_get_payroll_details (asg_action_id NUMBER) is
1011: SELECT ppf.payroll_name
1012: ,pcs.consolidation_set_name
1013: FROM pay_payroll_actions ppa
1014: ,pay_assignment_actions paa
1015: ,pay_payrolls_f ppf
1016: ,pay_consolidation_sets pcs
1017: WHERE ppa.payroll_action_id = paa.payroll_action_id
1018: AND ppa.payroll_id = ppf.payroll_id

Line 1064: FROM pay_assignment_actions paa

1060: IF ln_tax_unit_id IS NULL THEN
1061: hr_utility.set_location (l_proc_name ,15);
1062: SELECT tax_unit_id
1063: INTO ln_tax_unit_id
1064: FROM pay_assignment_actions paa
1065: WHERE paa.payroll_Action_id = ln_payroll_act_id
1066: AND assignment_action_id = ln_curr_assign_act_id;
1067: END IF;
1068:

Line 1535: FROM pay_assignment_actions paa,

1531: --Modified the sort query for sorting by employee name and payroll name
1532: hr_utility.set_location ('Entering'||l_proc_name ,20);
1533: sqlstr :=
1534: 'SELECT paa.rowid
1535: FROM pay_assignment_actions paa,
1536: pay_payroll_actions ppa
1537: WHERE ppa.payroll_action_id = :payactid
1538: and paa.payroll_action_id = ppa.payroll_action_id
1539: order by(pay_mx_payreg_pkg.sort_option (

Line 1553: pay_assignment_actions paa2

1549: ppa.effective_date,
1550: paa.tax_unit_id))),
1551: (SELECT ppa2.effective_date
1552: FROM pay_payroll_actions ppa2,
1553: pay_assignment_actions paa2
1554: WHERE paa2.assignment_action_id = to_number(substr(paa.serial_number,2))
1555: and paa2.payroll_action_id = ppa2.payroll_action_id
1556: and ppa2.action_type in (''R'', ''Q'', ''V'', ''B'')
1557: )