APPS.PER_JP_EMPDET_REPORT_PKG dependencies on PAY_ASSIGNMENT_ACTIONS_S

Line 1028: SELECT pay_assignment_actions_s.nextval

1024: --
1025: -- Added NVL to overcome NULL issue.
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

Line 1044: SELECT pay_assignment_actions_s.nextval

1040: ,p_assignment_id => lr_assact.assignment_id
1041: ,p_effective_date => gr_parameters.effective_date
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

Line 1075: SELECT pay_assignment_actions_s.nextval

1071: --
1072: -- Added NVL to overcome NULL issue.
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

Line 1091: SELECT pay_assignment_actions_s.nextval

1087: ,p_assignment_id => lr_assact.assignment_id
1088: ,p_effective_date => gr_parameters.effective_date
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

Line 1129: SELECT pay_assignment_actions_s.nextval

1125: -- Added NVL to overcome NULL issue.
1126: IF (NVL(ln_ass_set_id,0) = 0) THEN
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

Line 1145: SELECT pay_assignment_actions_s.nextval

1141: ,p_assignment_id => lr_assact.assignment_id
1142: ,p_effective_date => gr_parameters.effective_date
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

Line 1180: SELECT pay_assignment_actions_s.nextval

1176: -- Added NVL to overcome NULL issue.
1177: IF (NVL(ln_ass_set_id,0) = 0) THEN
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

Line 1196: SELECT pay_assignment_actions_s.nextval

1192: ,p_assignment_id => lr_assact.assignment_id
1193: ,p_effective_date => gr_parameters.effective_date
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