APPS.HRI_OPL_REC_CAND_PIPLN dependencies on PER_ALL_ASSIGNMENTS_F

Line 1960: per_all_assignments_f asg

1956: ,NVL(ast_irc.assignment_status_type_id, ast.assignment_status_type_id)
1957: assignment_status_type_id
1958: ,NVL(apl.termination_reason, 'NA_EDW') termination_reason
1959: FROM
1960: per_all_assignments_f asg
1961: ,per_assignment_status_types ast
1962: ,per_assignment_status_types ast_irc
1963: ,per_all_vacancies vac
1964: ,irc_assignment_statuses ias

Line 2209: per_all_assignments_f emp

2205: ,NVL(emp.grade_id, -1)
2206: ,NVL(emp.position_id, -1)
2207: ,emp.business_group_id
2208: FROM
2209: per_all_assignments_f emp
2210: ,per_periods_of_service pos
2211: WHERE emp.person_id = p_info_rec.psn_id
2212: AND emp.assignment_type = 'E'
2213: AND p_info_rec.appl_end_date + 1 BETWEEN emp.effective_start_date

Line 2236: per_all_assignments_f emp

2232: ,NVL(emp.grade_id, -1)
2233: ,NVL(emp.position_id, -1)
2234: ,emp.business_group_id
2235: FROM
2236: per_all_assignments_f emp
2237: ,per_periods_of_service pos
2238: WHERE emp.assignment_id = p_info_rec.asg_id
2239: AND emp.effective_start_date = pos.date_start
2240: AND emp.period_of_service_id = pos.period_of_service_id

Line 2551: FROM per_all_assignments_f

2547: CURSOR full_asg_csr IS
2548: SELECT DISTINCT
2549: assignment_id
2550: ,person_id
2551: FROM per_all_assignments_f
2552: WHERE assignment_type IN ('E','A')
2553: AND effective_end_date >= g_dbi_start_date
2554: AND assignment_id BETWEEN p_start_object_id AND p_end_object_id;
2555:

Line 2823: per_all_assignments_f asg

2819: p_sqlstr :=
2820: 'SELECT DISTINCT
2821: asg.assignment_id object_id
2822: FROM
2823: per_all_assignments_f asg
2824: WHERE asg.assignment_type IN (''E'',''A'')
2825: AND asg.effective_end_date >=
2826: hri_bpl_parameter.get_bis_global_start_date
2827: ORDER BY 1';

Line 2837: FROM per_all_assignments_f

2833: -- Set the SQL statement for the incremental range
2834: p_sqlstr :=
2835: 'SELECT DISTINCT
2836: assignment_id object_id
2837: FROM per_all_assignments_f
2838: WHERE 1 = 0
2839: ORDER BY 1';
2840:
2841: END IF;

Line 2916: FROM per_all_assignments_f

2912: ,CEIL(ROWNUM / 20) chunk_no
2913: FROM
2914: (SELECT DISTINCT
2915: assignment_id
2916: FROM per_all_assignments_f
2917: WHERE assignment_type IN ('E','A')
2918: AND effective_end_date >= g_dbi_start_date
2919: ORDER BY assignment_id
2920: ) tab

Line 2965: FROM per_all_assignments_f

2961: g_no_rows := 0;
2962: g_debug := TRUE;
2963:
2964: SELECT DISTINCT person_id INTO l_psn_id
2965: FROM per_all_assignments_f
2966: WHERE assignment_id = p_asg_id;
2967:
2968: DELETE FROM hri_mb_rec_cand_pipln_ct
2969: WHERE adt_assignment_id = p_asg_id;