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 174: pay_assignment_actions act,

170: sqlstr :=
171: 'select distinct asg.person_id
172: from pay_payroll_actions ppa,
173: pay_payroll_actions pa1,
174: pay_assignment_actions act,
175: per_assignments_f asg
176: where ppa.payroll_action_id = :payroll_action_id
177: '||l_consolidation_set_text||'
178: '||l_payroll_text||'

Line 243: from pay_assignment_actions act,

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

Line 299: from pay_assignment_actions act,

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

Line 354: from pay_assignment_actions act,

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

Line 409: from pay_assignment_actions act,

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

Line 464: from pay_assignment_actions act,

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

Line 519: from pay_assignment_actions act,

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

Line 573: from pay_assignment_actions act,

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

Line 628: from pay_assignment_actions act,

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

Line 682: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;

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

Line 755: select pay_assignment_actions_s.nextval

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

Line 769: select pay_assignment_actions_s.nextval

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

Line 826: select pay_assignment_actions_s.nextval

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

Line 839: select pay_assignment_actions_s.nextval

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

Line 895: select pay_assignment_actions_s.nextval

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

Line 908: select pay_assignment_actions_s.nextval

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

Line 964: select pay_assignment_actions_s.nextval

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

Line 977: select pay_assignment_actions_s.nextval

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

Line 1035: select pay_assignment_actions_s.nextval

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

Line 1049: select pay_assignment_actions_s.nextval

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

Line 1107: select pay_assignment_actions_s.nextval

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

Line 1121: select pay_assignment_actions_s.nextval

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

Line 1178: select pay_assignment_actions_s.nextval

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

Line 1190: select pay_assignment_actions_s.nextval

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

Line 1249: select pay_assignment_actions_s.nextval

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

Line 1266: select pay_assignment_actions_s.nextval

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

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

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

Line 1308: pay_assignment_actions paa1, /For Sorting /

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