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

Line 188: pay_assignment_actions act,

184: sqlstr :=
185: 'select distinct asg.person_id
186: from pay_payroll_actions ppa,
187: pay_payroll_actions pa1,
188: pay_assignment_actions act,
189: per_assignments_f asg,
190: pay_payrolls_f ppf
191: where ppa.payroll_action_id = :payroll_action_id
192: '||l_consolidation_set_text||'

Line 263: pay_assignment_actions act,

259: nvl(ppa.start_date,ppa.effective_date)
260: from pay_payrolls_f ppf, -- Bug 3372747
261: pay_payroll_actions ppa, /* pre-payments and reversals
262: payroll action id */
263: pay_assignment_actions act,
264: per_assignments_f paf
265: where (c_payroll_id is NULL
266: or ppa.payroll_id = c_payroll_id)
267: and ppa.consolidation_set_id +0 = nvl(c_consolidation_set_id,

Line 323: PAY_ASSIGNMENT_ACTIONS ACT ,

319: nvl(ppa.start_date,ppa.effective_date)
320: from
321: HR_ASSIGNMENT_SET_AMENDMENTS HASA ,
322: PER_ASSIGNMENTS_F PAF ,
323: PAY_ASSIGNMENT_ACTIONS ACT ,
324: PAY_PAYROLL_ACTIONS PPA ,
325: PAY_PAYROLLS_F PPF
326: where (c_payroll_id is NULL
327: or ppa.payroll_id = c_payroll_id)

Line 385: pay_assignment_actions paa,

381: cursor c_run_eff_date (cp_pre_pymt_action_id in number) is
382: select ppa.effective_date,
383: ppa.action_type
384: from pay_action_interlocks pai,
385: pay_assignment_actions paa,
386: pay_payroll_actions ppa
387: where pai.locking_action_id = cp_pre_pymt_action_id
388: and paa.assignment_action_id = pai.locked_action_id
389: and ppa.payroll_action_id = paa.payroll_action_id

Line 395: pay_assignment_actions paa,

391:
392: cursor c_payroll_run (cp_pre_pymt_action_id in number) is
393: select assignment_action_id, ppa.action_type
394: from pay_action_interlocks pai,
395: pay_assignment_actions paa,
396: pay_payroll_actions ppa
397: where pai.locking_action_id = cp_pre_pymt_action_id
398: and paa.assignment_action_id = pai.locked_action_id
399: and ppa.payroll_action_id = paa.payroll_action_id

Line 417: pay_assignment_actions paa,

413: -- Bug 4074976 -- Added a new cursor for Balance Adjustments for multiple assignment payroll.
414: cursor c_multi_ba_acts(cp_pre_pymt_action_id in number) is
415: select assignment_action_id, ppa.action_type
416: from pay_action_interlocks pai,
417: pay_assignment_actions paa,
418: pay_payroll_actions ppa
419: where pai.locking_action_id = cp_pre_pymt_action_id
420: and paa.assignment_action_id = pai.locked_action_id
421: and ppa.payroll_action_id = paa.payroll_action_id

Line 457: from pay_assignment_actions paa2, -- assignment_actions for slave payroll runs.

453:
454:
455: cursor c_multi_asg_acts (cp_pre_pymt_action_id in number) is
456: select max(paa2.assignment_action_id)
457: from pay_assignment_actions paa2, -- assignment_actions for slave payroll runs.
458: pay_assignment_actions paa1, -- assignment_action for master payroll run
459: pay_run_Types_f prt,
460: pay_payroll_actions ppa,
461: pay_action_interlocks pai

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

454:
455: cursor c_multi_asg_acts (cp_pre_pymt_action_id in number) is
456: select max(paa2.assignment_action_id)
457: from pay_assignment_actions paa2, -- assignment_actions for slave payroll runs.
458: pay_assignment_actions paa1, -- assignment_action for master payroll run
459: pay_run_Types_f prt,
460: pay_payroll_actions ppa,
461: pay_action_interlocks pai
462: where pai.locking_action_id = cp_pre_pymt_action_id

Line 483: from pay_assignment_actions paa2,

479: -- to only return the specific tu assignment actions.
480:
481: cursor c_multi_asg_rpt_acts (cp_pre_pymt_action_id in number) is
482: select distinct max(paa2.assignment_action_id)
483: from pay_assignment_actions paa2,
484: -- assignment_actions for slave payroll runs.
485: pay_assignment_actions paa1,
486: -- assignment_action for master payroll run
487: pay_run_Types_f prt,

Line 485: pay_assignment_actions paa1,

481: cursor c_multi_asg_rpt_acts (cp_pre_pymt_action_id in number) is
482: select distinct max(paa2.assignment_action_id)
483: from pay_assignment_actions paa2,
484: -- assignment_actions for slave payroll runs.
485: pay_assignment_actions paa1,
486: -- assignment_action for master payroll run
487: pay_run_Types_f prt,
488: pay_payroll_actions ppa,
489: pay_action_interlocks pai

Line 506: pay_assignment_actions paa,

502:
503: cursor c_check_for_void (cp_pre_pymt_action_id in number) is
504: select 'Y'
505: from pay_action_interlocks pai,
506: pay_assignment_actions paa,
507: pay_payroll_actions ppa
508: where pai.locking_action_id = cp_pre_pymt_action_id
509: and paa.assignment_action_id = pai.locked_action_id
510: and ppa.payroll_action_id = paa.payroll_action_id

Line 549: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;

545:
546: l_payroll_id pay_payroll_actions.payroll_id%TYPE;
547: l_location_id per_all_assignments_f.location_id%TYPE;
548: l_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE;
549: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
550: l_person_id per_all_assignments_f.person_id%TYPE;
551: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
552: l_organization_id per_all_assignments_f.organization_id%TYPE;
553: l_assignment_set_id hr_assignment_set_amendments.assignment_set_id%TYPE;

Line 749: select pay_assignment_actions_s.nextval

745: fetch c_payments into runactid;
746: exit when c_payments%NOTFOUND;
747: if runactid is not null then -- Bug 3928632
748:
749: select pay_assignment_actions_s.nextval
750: into lockingactid
751: from dual;
752:
753: -- insert the action record.

Line 766: -- update pay_assignment_actions serial_number with runactid.

762: lv_sep_check ||
763: lv_multi_asg_flag ||
764: to_char(runactid);
765:
766: -- update pay_assignment_actions serial_number with runactid.
767:
768: update pay_assignment_actions
769: set serial_number = serialno
770: where assignment_action_id = lockingactid

Line 768: update pay_assignment_actions

764: to_char(runactid);
765:
766: -- update pay_assignment_actions serial_number with runactid.
767:
768: update pay_assignment_actions
769: set serial_number = serialno
770: where assignment_action_id = lockingactid
771: and tax_unit_id = greid;
772:

Line 826: select pay_assignment_actions_s.nextval

822: fetch c_multi_asg_acts into runactid;
823:
824: close c_multi_asg_acts;
825:
826: select pay_assignment_actions_s.nextval
827: into lockingactid
828: from dual;
829:
830: -- insert the action record.

Line 860: -- update pay_assignment_actions serial_number with runactid.

856: lv_sep_check ||
857: lv_multi_asg_flag ||
858: to_char(l_asg_act_id);
859:
860: -- update pay_assignment_actions serial_number with runactid.
861:
862: update pay_assignment_actions
863: set serial_number = serialno
864: where assignment_action_id = lockingactid

Line 862: update pay_assignment_actions

858: to_char(l_asg_act_id);
859:
860: -- update pay_assignment_actions serial_number with runactid.
861:
862: update pay_assignment_actions
863: set serial_number = serialno
864: where assignment_action_id = lockingactid
865: and tax_unit_id = greid;
866: lv_max_run_flag := 'Y' ;

Line 883: -- update pay_assignment_actions serial_number with runactid.

879: lv_sep_check ||
880: lv_multi_asg_flag ||
881: to_char(runactid);
882:
883: -- update pay_assignment_actions serial_number with runactid.
884:
885: update pay_assignment_actions
886: set serial_number = serialno
887: where assignment_action_id = lockingactid

Line 885: update pay_assignment_actions

881: to_char(runactid);
882:
883: -- update pay_assignment_actions serial_number with runactid.
884:
885: update pay_assignment_actions
886: set serial_number = serialno
887: where assignment_action_id = lockingactid
888: and tax_unit_id = greid;
889: end if;

Line 928: select pay_assignment_actions_s.nextval

924: end if; -- source action id is null
925:
926: ELSE -- This is a void action.
927:
928: select pay_assignment_actions_s.nextval
929: into lockingactid
930: from dual;
931:
932: hr_utility.trace('B4 insact'||to_char(lockingactid) ||','||to_char(greid)||','||actiontype||','||to_char(runactid) );

Line 944: -- update pay_assignment_actions serial_number with runactid.

940:
941: begin
942: --serialno := 'V'||to_char(runactid);
943: serialno := actiontype || 'NN' || to_char(lockedactid);
944: -- update pay_assignment_actions serial_number with runactid.
945: update pay_assignment_actions
946: set serial_number = serialno
947: where assignment_action_id = lockingactid
948: and tax_unit_id = greid;

Line 945: update pay_assignment_actions

941: begin
942: --serialno := 'V'||to_char(runactid);
943: serialno := actiontype || 'NN' || to_char(lockedactid);
944: -- update pay_assignment_actions serial_number with runactid.
945: update pay_assignment_actions
946: set serial_number = serialno
947: where assignment_action_id = lockingactid
948: and tax_unit_id = greid;
949: exception when others then

Line 1010: select pay_assignment_actions_s.nextval

1006: -- we have a zero net pay pre-pay assignment_action
1007: -- insert one row for the action creation.
1008: -- insert the action record.
1009:
1010: select pay_assignment_actions_s.nextval
1011: into lockingactid
1012: from dual;
1013:
1014: -- insert the action record.

Line 1043: -- update pay_assignment_actions serial_number with runactid.

1039: lv_sep_check ||
1040: 'N' || -- multi_asg_flag
1041: to_char(runactid);
1042:
1043: -- update pay_assignment_actions serial_number with runactid.
1044:
1045: update pay_assignment_actions
1046: set serial_number = serialno
1047: where assignment_action_id = lockingactid

Line 1045: update pay_assignment_actions

1041: to_char(runactid);
1042:
1043: -- update pay_assignment_actions serial_number with runactid.
1044:
1045: update pay_assignment_actions
1046: set serial_number = serialno
1047: where assignment_action_id = lockingactid
1048: and tax_unit_id = greid;
1049:

Line 1090: select pay_assignment_actions_s.nextval

1086: ln_source_action_id <> ln_prev_source_action_id or
1087: ln_source_action_id = -999) then
1088:
1089: -- insert the action record.
1090: select pay_assignment_actions_s.nextval
1091: into lockingactid
1092: from dual;
1093:
1094: l_action_insert := 'Y';

Line 1110: -- update pay_assignment_actions serial_number with runactid.

1106: lv_sep_check ||
1107: 'N' || -- multi_asg_flag
1108: to_char(runactid);
1109:
1110: -- update pay_assignment_actions serial_number with runactid.
1111:
1112: update pay_assignment_actions
1113: set serial_number = serialno
1114: where assignment_action_id = lockingactid

Line 1112: update pay_assignment_actions

1108: to_char(runactid);
1109:
1110: -- update pay_assignment_actions serial_number with runactid.
1111:
1112: update pay_assignment_actions
1113: set serial_number = serialno
1114: where assignment_action_id = lockingactid
1115: and tax_unit_id = greid;
1116:

Line 1164: -- update pay_assignment_actions serial_number with runactid.

1160: lv_sep_check ||
1161: 'N' || -- multi_asg_flag
1162: to_char(runactid);
1163:
1164: -- update pay_assignment_actions serial_number with runactid.
1165:
1166: update pay_assignment_actions
1167: set serial_number = serialno
1168: where assignment_action_id = lockingactid

Line 1166: update pay_assignment_actions

1162: to_char(runactid);
1163:
1164: -- update pay_assignment_actions serial_number with runactid.
1165:
1166: update pay_assignment_actions
1167: set serial_number = serialno
1168: where assignment_action_id = lockingactid
1169: and tax_unit_id = greid;
1170:

Line 1207: select pay_assignment_actions_s.nextval

1203: close c_payment_info;
1204:
1205: ELSE -- This is a void action.
1206:
1207: select pay_assignment_actions_s.nextval
1208: into lockingactid
1209: from dual;
1210:
1211: hr_utility.trace('B4 insact'||to_char(lockingactid) ||','||to_char(greid)||','||actiontype||','||to_char(runactid) );

Line 1223: -- update pay_assignment_actions serial_number with runactid.

1219:
1220: begin
1221: --serialno := 'V'||to_char(runactid);
1222: serialno := actiontype || 'NN' || to_char(lockedactid);
1223: -- update pay_assignment_actions serial_number with runactid.
1224: update pay_assignment_actions
1225: set serial_number = serialno
1226: where assignment_action_id = lockingactid
1227: and tax_unit_id = greid;

Line 1224: update pay_assignment_actions

1220: begin
1221: --serialno := 'V'||to_char(runactid);
1222: serialno := actiontype || 'NN' || to_char(lockedactid);
1223: -- update pay_assignment_actions serial_number with runactid.
1224: update pay_assignment_actions
1225: set serial_number = serialno
1226: where assignment_action_id = lockingactid
1227: and tax_unit_id = greid;
1228: exception when others then

Line 1292: from pay_assignment_actions paa,

1288:
1289:
1290: sqlstr :=
1291: 'select paa.rowid
1292: from pay_assignment_actions paa,
1293: pay_payroll_actions ppa
1294: where ppa.payroll_action_id = :payactid
1295: and paa.payroll_action_id = ppa.payroll_action_id
1296: order by

Line 1338: pay_assignment_actions paa2

1334: ppf.effective_start_date and ppf.effective_end_date
1335: ),
1336: (select ppa2.effective_date
1337: from pay_payroll_actions ppa2,
1338: pay_assignment_actions paa2
1339: where paa2.assignment_action_id = to_number(substr(paa.serial_number,4))
1340: and paa2.payroll_action_id = ppa2.payroll_action_id
1341: and ppa2.action_type in (''R'', ''Q'', ''V'', ''B'')
1342: )