1026: IF (NVL(ln_ass_set_id,0) = 0) THEN
1027: -- NO assignment set passed as parameter
1028: SELECT pay_assignment_actions_s.nextval
1029: INTO ln_assact
1030: FROM dual;
1031: hr_nonrun_asact.insact(ln_assact
1032: ,lr_assact.assignment_id
1033: ,p_payroll_action_id
1034: ,p_chunk
1042: );
1043: IF lc_include_flag = 'Y' THEN
1044: SELECT pay_assignment_actions_s.nextval
1045: INTO ln_assact
1046: FROM dual;
1047: hr_nonrun_asact.insact(ln_assact
1048: ,lr_assact.assignment_id
1049: ,p_payroll_action_id
1050: ,p_chunk
1073: IF (NVL(ln_ass_set_id,0) = 0) THEN
1074: -- NO assignment set passed as parameter
1075: SELECT pay_assignment_actions_s.nextval
1076: INTO ln_assact
1077: FROM dual;
1078: hr_nonrun_asact.insact(ln_assact
1079: ,lr_assact.assignment_id
1080: ,p_payroll_action_id
1081: ,p_chunk
1089: );
1090: IF lc_include_flag = 'Y' THEN
1091: SELECT pay_assignment_actions_s.nextval
1092: INTO ln_assact
1093: FROM dual;
1094: hr_nonrun_asact.insact(ln_assact
1095: ,lr_assact.assignment_id
1096: ,p_payroll_action_id
1097: ,p_chunk
1127: --
1128: -- NO assignment set passed as parameter
1129: SELECT pay_assignment_actions_s.nextval
1130: INTO ln_assact
1131: FROM dual;
1132: hr_nonrun_asact.insact(ln_assact
1133: ,lr_assact.assignment_id
1134: ,p_payroll_action_id
1135: ,p_chunk
1143: );
1144: IF lc_include_flag = 'Y' THEN
1145: SELECT pay_assignment_actions_s.nextval
1146: INTO ln_assact
1147: FROM dual;
1148: hr_nonrun_asact.insact(ln_assact
1149: ,lr_assact.assignment_id
1150: ,p_payroll_action_id
1151: ,p_chunk
1178: --
1179: -- NO assignment set passed as parameter
1180: SELECT pay_assignment_actions_s.nextval
1181: INTO ln_assact
1182: FROM dual;
1183: hr_nonrun_asact.insact(ln_assact
1184: ,lr_assact.assignment_id
1185: ,p_payroll_action_id
1186: ,p_chunk
1194: );
1195: IF lc_include_flag = 'Y' THEN
1196: SELECT pay_assignment_actions_s.nextval
1197: INTO ln_assact
1198: FROM dual;
1199: hr_nonrun_asact.insact(ln_assact
1200: ,lr_assact.assignment_id
1201: ,p_payroll_action_id
1202: ,p_chunk