DBA Data[Home] [Help]

APPS.PER_JP_EMPDET_REPORT_PKG dependencies on DUAL

Line 1030: FROM dual;

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

Line 1046: FROM dual;

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

Line 1077: FROM dual;

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

Line 1093: FROM dual;

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

Line 1131: FROM dual;

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

Line 1147: FROM dual;

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

Line 1182: FROM dual;

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

Line 1198: FROM dual;

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