DBA Data[Home] [Help]

APPS.PAY_JP_IWHT_ARCH_PKG dependencies on PER_ALL_PEOPLE_F

Line 575: ,p_start_person IN per_all_people_f.person_id%type

571: END range_person_on;
572: --
573: --
574: PROCEDURE assignment_action_code( p_payroll_action_id IN pay_payroll_actions.payroll_action_id%type
575: ,p_start_person IN per_all_people_f.person_id%type
576: ,p_end_person IN per_all_people_f.person_id%type
577: ,p_chunk IN NUMBER
578: )
579: --************************************************************************

Line 576: ,p_end_person IN per_all_people_f.person_id%type

572: --
573: --
574: PROCEDURE assignment_action_code( p_payroll_action_id IN pay_payroll_actions.payroll_action_id%type
575: ,p_start_person IN per_all_people_f.person_id%type
576: ,p_end_person IN per_all_people_f.person_id%type
577: ,p_chunk IN NUMBER
578: )
579: --************************************************************************
580: -- PROCEDURE

Line 671: ,p_start_person_id per_all_people_f.person_id%TYPE

667: AND PPAV.action_type = 'V'))
668: ORDER BY PAF.assignment_id;
669: --
670: CURSOR lcu_emp_assignment_det ( p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE
671: ,p_start_person_id per_all_people_f.person_id%TYPE
672: ,p_end_person_id per_all_people_f.person_id%TYPE
673: ,p_business_group_id per_assignments_f.business_group_id%TYPE
674: ,p_effective_date DATE
675: ,p_payroll_id pay_payrolls_f.payroll_id%TYPE

Line 672: ,p_end_person_id per_all_people_f.person_id%TYPE

668: ORDER BY PAF.assignment_id;
669: --
670: CURSOR lcu_emp_assignment_det ( p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE
671: ,p_start_person_id per_all_people_f.person_id%TYPE
672: ,p_end_person_id per_all_people_f.person_id%TYPE
673: ,p_business_group_id per_assignments_f.business_group_id%TYPE
674: ,p_effective_date DATE
675: ,p_payroll_id pay_payrolls_f.payroll_id%TYPE
676: ,p_with_hold_id hr_all_organization_units.organization_id%TYPE