APPS.PAY_PAYACT_PKG dependencies on PAY_ASSIGNMENT_ACTIONS_S

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.