DBA Data[Home] [Help]

APPS.PA_COST1 dependencies on PER_JOBS_V

Line 1181: from per_jobs_v

1177: if p_person_id is not null then
1178: if p_job_id is null then
1179: select name
1180: into pa_pay_util.g_job_name
1181: from per_jobs_v
1182: where job_id = pa_utils.getempjobid(X_person_id => p_person_id, X_date => p_exp_item_date);
1183:
1184: l_stage := 'RBC: Employee Job name: ' || pa_pay_util.g_job_name;
1185: print_msg(l_debug_flag,l_stage);

Line 1189: from per_jobs_v

1185: print_msg(l_debug_flag,l_stage);
1186: elsif p_job_id is not null then
1187: select name
1188: into pa_pay_util.g_job_name
1189: from per_jobs_v
1190: where job_id = p_job_id;
1191:
1192: l_stage := 'RBC: Job name: ' || pa_pay_util.g_job_name;
1193: print_msg(l_debug_flag,l_stage);

Line 1211: from per_jobs_v

1207:
1208: if p_job_id is not null then
1209: select name
1210: into pa_pay_util.g_job_name
1211: from per_jobs_v
1212: where job_id = p_job_id;
1213:
1214: l_stage := 'RBC: Job name: ' || pa_pay_util.g_job_name;
1215: print_msg(l_debug_flag,l_stage);

Line 1222: from per_jobs_v

1218:
1219: if l_job_flag = 'Y' then
1220: select name
1221: into pa_pay_util.g_job_name
1222: from per_jobs_v
1223: where job_id = l_asgn_rec.job_id;
1224:
1225: l_stage := 'RBC for BnF: Job Flag: ' || l_job_flag ||', Job name: ' || pa_pay_util.g_job_name;
1226: print_msg(l_debug_flag,l_stage);

Line 1234: from per_jobs_v

1230: -- find the job for the team role
1231: begin
1232: select name
1233: into pa_pay_util.g_job_name
1234: from per_jobs_v
1235: where job_id = (select a.default_job_id
1236: from pa_project_role_types_vl a
1237: where a.project_role_id = l_asgn_rec.project_role_id);
1238:

Line 1254: from per_jobs_v

1250: if pa_pay_util.g_job_name is null then
1251: begin
1252: select name
1253: into pa_pay_util.g_job_name
1254: from per_jobs_v
1255: where job_id = pa_utils.getempjobid(X_person_id => p_person_id, X_date => p_exp_item_date);
1256:
1257: l_stage := 'RBC for BnF: Named Person Flag: ' || l_named_person_flag ||', Employee Job name: ' || pa_pay_util.g_job_name;
1258: print_msg(l_debug_flag,l_stage);