APPS.HR_MX_UTILITY dependencies on PER_ALL_ASSIGNMENTS_F

Line 326: p_assignment_id per_all_assignments_f.assignment_id%TYPE)

322: -- --
323: --------------------------------------------------------------------------
324:
325: FUNCTION GET_BG_FROM_ASSIGNMENT (
326: p_assignment_id per_all_assignments_f.assignment_id%TYPE)
327: RETURN per_all_assignments_f.business_group_id%TYPE AS
328:
329: CURSOR csr_fetch_bg IS
330: SELECT business_group_id

Line 327: RETURN per_all_assignments_f.business_group_id%TYPE AS

323: --------------------------------------------------------------------------
324:
325: FUNCTION GET_BG_FROM_ASSIGNMENT (
326: p_assignment_id per_all_assignments_f.assignment_id%TYPE)
327: RETURN per_all_assignments_f.business_group_id%TYPE AS
328:
329: CURSOR csr_fetch_bg IS
330: SELECT business_group_id
331: FROM per_assignments_f

Line 335: l_bg_id per_all_assignments_f.business_group_id%TYPE;

331: FROM per_assignments_f
332: WHERE assignment_id = p_assignment_id
333: AND rownum < 2;
334:
335: l_bg_id per_all_assignments_f.business_group_id%TYPE;
336:
337: BEGIN
338: OPEN csr_fetch_bg;
339: FETCH csr_fetch_bg INTO l_bg_id;

Line 1293: per_all_assignments_f paa

1289: CURSOR c_get_adj_svc_date
1290: IS
1291: SELECT pps.adjusted_svc_date
1292: FROM per_periods_of_service pps,
1293: per_all_assignments_f paa
1294: WHERE paa.assignment_id = p_assignment_id
1295: AND p_effective_date BETWEEN paa.effective_start_date
1296: AND paa.effective_end_date
1297: AND pps.person_id = paa.person_id

Line 1309: per_all_assignments_f paa

1305: CURSOR c_get_first_hire_date
1306: IS
1307: SELECT original_date_of_hire
1308: FROM per_all_people_f pap,
1309: per_all_assignments_f paa
1310: WHERE paa.assignment_id = p_assignment_id
1311: AND p_effective_date BETWEEN paa.effective_start_date
1312: AND paa.effective_end_date
1313: AND pap.person_id = paa.person_id

Line 1321: FROM per_all_assignments_f paa,

1317: -- cursor to get the latest hire date
1318: CURSOR c_get_latest_hire_date
1319: IS
1320: SELECT max(pps.date_start)
1321: FROM per_all_assignments_f paa,
1322: per_periods_of_service pps
1323: WHERE paa.assignment_id = p_assignment_id
1324: AND p_effective_date BETWEEN paa.effective_start_date
1325: AND paa.effective_end_date