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

Line 177: pay_assignment_actions act,

173: 'select /*+ leading(ppa,pa1,act,asg) use_nl(ppa, pa1, act, asg) index(pa1,PAY_PAYROLL_ACTIONS_N5) */
174: distinct asg.person_id
175: from pay_payroll_actions ppa,
176: pay_payroll_actions pa1,
177: pay_assignment_actions act,
178: per_assignments_f asg
179: where ppa.payroll_action_id = :payroll_action_id
180: '||l_consolidation_set_text||'
181: '||l_payroll_text||'

Line 246: from pay_assignment_actions act,

242: ) is --Bug 3372732
243: select act.assignment_action_id,
244: act.assignment_id,
245: act.tax_unit_id
246: from pay_assignment_actions act,
247: per_assignments_f paf,
248: pay_payroll_actions ppa, /* pre-payments and reversals
249: payroll action id */
250: pay_payrolls_f ppf -- Bug 3372732

Line 302: from pay_assignment_actions act,

298: ) is -- Bug 3372737
299: select act.assignment_action_id,
300: act.assignment_id,
301: act.tax_unit_id
302: from pay_assignment_actions act,
303: per_assignments_f paf,
304: pay_payroll_actions ppa, /* pre-payments and reversals payroll action id */
305: pay_payrolls_f ppf -- Bug 3372732
306: where ppa.payroll_id = nvl(c_payroll_id, ppa.payroll_id)

Line 357: from pay_assignment_actions act,

353: ) is
354: select act.assignment_action_id,
355: act.assignment_id,
356: act.tax_unit_id
357: from pay_assignment_actions act,
358: per_assignments_f paf,
359: pay_payroll_actions ppa, /* pre-payments and reversals payroll action id */
360: pay_payrolls_f ppf -- Bug 3372732
361: where ppa.payroll_id =

Line 412: from pay_assignment_actions act,

408: ) is
409: select act.assignment_action_id,
410: act.assignment_id,
411: act.tax_unit_id
412: from pay_assignment_actions act,
413: per_assignments_f paf,
414: pay_payroll_actions ppa, /* pre-payments and reversals */
415: /* payroll action id */
416: pay_payrolls_f ppf -- Bug 3372732

Line 467: from pay_assignment_actions act,

463: ) is
464: select act.assignment_action_id,
465: act.assignment_id,
466: act.tax_unit_id
467: from pay_assignment_actions act,
468: per_assignments_f paf,
469: pay_payroll_actions ppa, /* pre-payments and */
470: /* reversals payroll action id */
471: pay_payrolls_f ppf -- Bug 3372732

Line 522: from pay_assignment_actions act,

518: ) is -- Bug 3372732
519: select act.assignment_action_id,
520: act.assignment_id,
521: act.tax_unit_id
522: from pay_assignment_actions act,
523: per_assignments_f paf,
524: pay_payroll_actions ppa, /* pre-payments and */
525: /* reversals payroll action id */
526: pay_payrolls_f ppf

Line 576: from pay_assignment_actions act,

572: ) is --Bug 3372732
573: select act.assignment_action_id,
574: act.assignment_id,
575: act.tax_unit_id
576: from pay_assignment_actions act,
577: per_assignments_f paf,
578: pay_payroll_actions ppa, /* pre-payments and */
579: /* reversals payroll action id */
580: pay_payrolls_f ppf -- Bug 3372732

Line 631: from pay_assignment_actions act,

627: ) is -- Bug 3372732
628: select act.assignment_action_id,
629: act.assignment_id,
630: act.tax_unit_id
631: from pay_assignment_actions act,
632: per_assignments_f paf,
633: pay_payroll_actions ppa, /* pre-payments and */
634: /* reversals payroll action id */
635: pay_payrolls_f ppf

Line 685: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;

681: --
682: l_payroll_id pay_payroll_actions.payroll_id%TYPE;
683: l_location_id per_all_assignments_f.location_id%TYPE;
684: l_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE;
685: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
686: l_person_id per_all_assignments_f.person_id%TYPE;
687: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
688: l_organization_id per_all_assignments_f.organization_id%TYPE;
689: l_start_date pay_payroll_actions.effective_date%TYPE;

Line 758: select pay_assignment_actions_s.nextval

754:
755: If ass_flag = 'Y' then
756:
757: hr_utility.set_location('procpyr',3);
758: select pay_assignment_actions_s.nextval
759: into lockingactid
760: from dual;
761:
762: -- insert the action record.

Line 772: select pay_assignment_actions_s.nextval

768: End if;
769: else
770:
771: hr_utility.set_location('procpyr',30);
772: select pay_assignment_actions_s.nextval
773: into lockingactid
774: from dual;
775:
776: -- insert the action record.

Line 829: select pay_assignment_actions_s.nextval

825:
826: If ass_flag = 'Y' then
827:
828: hr_utility.set_location('procpyr',3);
829: select pay_assignment_actions_s.nextval
830: into lockingactid
831: from dual;
832:
833: -- insert the action record.

Line 842: select pay_assignment_actions_s.nextval

838:
839: end if;
840: else
841: hr_utility.set_location('procpyr',3);
842: select pay_assignment_actions_s.nextval
843: into lockingactid
844: from dual;
845:
846: -- insert the action record.

Line 898: select pay_assignment_actions_s.nextval

894:
895: If ass_flag = 'Y' then
896:
897: hr_utility.set_location('procpyr',3);
898: select pay_assignment_actions_s.nextval
899: into lockingactid
900: from dual;
901:
902: -- insert the action record.

Line 911: select pay_assignment_actions_s.nextval

907:
908: end if;
909: else
910: hr_utility.set_location('procpyr',3);
911: select pay_assignment_actions_s.nextval
912: into lockingactid
913: from dual;
914:
915: -- insert the action record.

Line 967: select pay_assignment_actions_s.nextval

963:
964: If ass_flag = 'Y' then
965:
966: hr_utility.set_location('procpyr',3);
967: select pay_assignment_actions_s.nextval
968: into lockingactid
969: from dual;
970:
971: -- insert the action record.

Line 980: select pay_assignment_actions_s.nextval

976:
977: end if;
978: else
979: hr_utility.set_location('procpyr',3);
980: select pay_assignment_actions_s.nextval
981: into lockingactid
982: from dual;
983:
984: -- insert the action record.

Line 1038: select pay_assignment_actions_s.nextval

1034:
1035: If ass_flag = 'Y' then
1036:
1037: hr_utility.set_location('procpyr',3);
1038: select pay_assignment_actions_s.nextval
1039: into lockingactid
1040: from dual;
1041:
1042: -- insert the action record.

Line 1052: select pay_assignment_actions_s.nextval

1048: end if;
1049: else
1050:
1051: hr_utility.set_location('procpyr',3);
1052: select pay_assignment_actions_s.nextval
1053: into lockingactid
1054: from dual;
1055:
1056: -- insert the action record.

Line 1110: select pay_assignment_actions_s.nextval

1106:
1107: If ass_flag = 'Y' then
1108:
1109: hr_utility.set_location('procpyr',3);
1110: select pay_assignment_actions_s.nextval
1111: into lockingactid
1112: from dual;
1113:
1114: -- insert the action record.

Line 1124: select pay_assignment_actions_s.nextval

1120: end if;
1121: else
1122:
1123: hr_utility.set_location('procpyr',3);
1124: select pay_assignment_actions_s.nextval
1125: into lockingactid
1126: from dual;
1127: --
1128: -- insert the action record.

Line 1181: select pay_assignment_actions_s.nextval

1177:
1178: If ass_flag = 'Y' then
1179:
1180: hr_utility.set_location('procpyr',3);
1181: select pay_assignment_actions_s.nextval
1182: into lockingactid
1183: from dual;
1184:
1185: -- insert the action record.

Line 1193: select pay_assignment_actions_s.nextval

1189: hr_nonrun_asact.insint(lockingactid,lockedactid);
1190: end if;
1191: else
1192: hr_utility.set_location('procpyr',3);
1193: select pay_assignment_actions_s.nextval
1194: into lockingactid
1195: from dual;
1196:
1197: -- insert the action record.

Line 1252: select pay_assignment_actions_s.nextval

1248: -- we need to insert one action for each of the
1249: -- rows that we return from the cursor (i.e. one
1250: -- for each assignment/pre-payment/reversal).
1251: hr_utility.set_location('procpyr',3);
1252: select pay_assignment_actions_s.nextval
1253: into lockingactid
1254: from dual;
1255:
1256: -- insert the action record.

Line 1269: select pay_assignment_actions_s.nextval

1265: -- we need to insert one action for each of the
1266: -- rows that we return from the cursor (i.e. one
1267: -- for each assignment/pre-payment/reversal).
1268: hr_utility.set_location('procpyr',3);
1269: select pay_assignment_actions_s.nextval
1270: into lockingactid
1271: from dual;
1272:
1273: -- insert the action record.

Line 1309: pay_assignment_actions paa, /* PYUGEN assignment action */

1305: hr_all_organization_units hou1,/* Tax Unit */
1306: hr_locations_all loc,
1307: per_all_people_f ppf,
1308: per_all_assignments_f paf,
1309: pay_assignment_actions paa, /* PYUGEN assignment action */
1310: pay_payroll_actions ppa, /* PYUGEN payroll action id */
1311: pay_assignment_actions paa1, /*For Sorting */
1312: pay_action_interlocks pai,
1313: pay_payroll_actions ppa1 /*For Sorting */

Line 1311: pay_assignment_actions paa1, /For Sorting /

1307: per_all_people_f ppf,
1308: per_all_assignments_f paf,
1309: pay_assignment_actions paa, /* PYUGEN assignment action */
1310: pay_payroll_actions ppa, /* PYUGEN payroll action id */
1311: pay_assignment_actions paa1, /*For Sorting */
1312: pay_action_interlocks pai,
1313: pay_payroll_actions ppa1 /*For Sorting */
1314: where ppa.payroll_action_id = :payactid
1315: and paa.payroll_action_id = ppa.payroll_action_id