APPS.PER_CAGR_APPLY_RESULTS_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 88: FROM per_all_assignments_f asg

84:
85: -- get the assignments for the SC mode process
86: CURSOR csr_assignments_to_process IS
87: SELECT assignment_id
88: FROM per_all_assignments_f asg
89: WHERE asg.collective_agreement_id = p_params.collective_agreement_id
90: AND p_params.effective_date BETWEEN asg.effective_start_date
91: AND asg.effective_end_date
92: AND asg.PRIMARY_FLAG = 'Y';

Line 398: get_ovn_and_mode (p_table_name => 'PER_ALL_ASSIGNMENTS_F'

394: ELSE
395: l_probation_end_date := hr_api.g_date;
396: END IF;
397:
398: get_ovn_and_mode (p_table_name => 'PER_ALL_ASSIGNMENTS_F'
399: ,p_dt_flag => 'Y'
400: ,p_pk => 'assignment_id'
401: ,p_pk_id => p_params.assignment_id
402: ,p_effective_date => p_params.effective_date

Line 517: get_ovn_and_mode (p_table_name => 'PER_ALL_ASSIGNMENTS_F'

513: END;
514:
515: elsif l_api_details(1).api_name = 'HR_ASSIGNMENT_API.UPDATE_EMP_ASG_CRITERIA' then
516:
517: get_ovn_and_mode (p_table_name => 'PER_ALL_ASSIGNMENTS_F'
518: ,p_dt_flag => 'Y'
519: ,p_pk => 'assignment_id'
520: ,p_pk_id => p_params.assignment_id
521: ,p_effective_date => p_params.effective_date