APPS.PAY_JP_UITE_ARCH_PKG dependencies on PER_ALL_PEOPLE_F

Line 2358: ,p_start_person IN per_all_people_f.person_id%type

2354: RETURN lb_return;
2355: END range_person_on;
2356: --
2357: PROCEDURE assignment_action_code ( p_payroll_action_id IN pay_payroll_actions.payroll_action_id%type
2358: ,p_start_person IN per_all_people_f.person_id%type
2359: ,p_end_person IN per_all_people_f.person_id%type
2360: ,p_chunk IN NUMBER
2361: )
2362: --************************************************************************

Line 2359: ,p_end_person IN per_all_people_f.person_id%type

2355: END range_person_on;
2356: --
2357: PROCEDURE assignment_action_code ( p_payroll_action_id IN pay_payroll_actions.payroll_action_id%type
2358: ,p_start_person IN per_all_people_f.person_id%type
2359: ,p_end_person IN per_all_people_f.person_id%type
2360: ,p_chunk IN NUMBER
2361: )
2362: --************************************************************************
2363: -- PROCEDURE

Line 2430: CURSOR lcu_emp_assignment_det ( p_start_person_id per_all_people_f.person_id%TYPE

2426: AND NVL(get_ei_dis_qual_date(PAF.assignment_id,NVL(PPS.actual_termination_date,PPS.projected_termination_date))-1,TO_DATE('31/12/4712','dd/mm/yyyy'))
2427: AND get_term_rpt_flag(PAF.assignment_id,NVL(PPS.actual_termination_date,PPS.projected_termination_date))= 'Y'
2428: ORDER BY PAF.assignment_id;
2429: --
2430: CURSOR lcu_emp_assignment_det ( p_start_person_id per_all_people_f.person_id%TYPE
2431: ,p_end_person_id per_all_people_f.person_id%TYPE
2432: ,p_business_group_id per_assignments_f.business_group_id%TYPE
2433: ,p_organization_id per_assignments_f.organization_id%TYPE
2434: ,p_effective_date DATE

Line 2431: ,p_end_person_id per_all_people_f.person_id%TYPE

2427: AND get_term_rpt_flag(PAF.assignment_id,NVL(PPS.actual_termination_date,PPS.projected_termination_date))= 'Y'
2428: ORDER BY PAF.assignment_id;
2429: --
2430: CURSOR lcu_emp_assignment_det ( p_start_person_id per_all_people_f.person_id%TYPE
2431: ,p_end_person_id per_all_people_f.person_id%TYPE
2432: ,p_business_group_id per_assignments_f.business_group_id%TYPE
2433: ,p_organization_id per_assignments_f.organization_id%TYPE
2434: ,p_effective_date DATE
2435: ,p_start_date DATE