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 390: get_ovn_and_mode (p_table_name => 'PER_ALL_ASSIGNMENTS_F'

386: per_cagr_utility_pkg.put_log(' built mapping array of size: '||l_map_count);
387: if l_mapping_table.count > 0 then
388: if l_api_details(1).api_name = 'HR_ASSIGNMENT_API.UPDATE_EMP_ASG' then
389:
390: get_ovn_and_mode (p_table_name => 'PER_ALL_ASSIGNMENTS_F'
391: ,p_dt_flag => 'Y'
392: ,p_pk => 'assignment_id'
393: ,p_pk_id => p_params.assignment_id
394: ,p_effective_date => p_params.effective_date

Line 509: get_ovn_and_mode (p_table_name => 'PER_ALL_ASSIGNMENTS_F'

505: END;
506:
507: elsif l_api_details(1).api_name = 'HR_ASSIGNMENT_API.UPDATE_EMP_ASG_CRITERIA' then
508:
509: get_ovn_and_mode (p_table_name => 'PER_ALL_ASSIGNMENTS_F'
510: ,p_dt_flag => 'Y'
511: ,p_pk => 'assignment_id'
512: ,p_pk_id => p_params.assignment_id
513: ,p_effective_date => p_params.effective_date