APPS.PAY_AU_REC_DET_PAYSUM_MODE dependencies on PER_ALL_PEOPLE_F

Line 405: ,p_start_person in per_all_people_f.person_id%type

401: --------------------------------------------------------------------+
402:
403: procedure assignment_action_code
404: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type
405: ,p_start_person in per_all_people_f.person_id%type
406: ,p_end_person in per_all_people_f.person_id%type
407: ,p_chunk in number
408: ) is
409: cursor get_ps_params(c_payroll_action_id per_all_assignments_f.assignment_id%type)

Line 406: ,p_end_person in per_all_people_f.person_id%type

402:
403: procedure assignment_action_code
404: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type
405: ,p_start_person in per_all_people_f.person_id%type
406: ,p_end_person in per_all_people_f.person_id%type
407: ,p_chunk in number
408: ) is
409: cursor get_ps_params(c_payroll_action_id per_all_assignments_f.assignment_id%type)
410: is

Line 434: ,c_start_person per_all_people_f.person_id%type

430: --
431: --------------------------------------------------------------------+
432: cursor csr_assignment_paysum
433: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
434: ,c_start_person per_all_people_f.person_id%type
435: ,c_end_person per_all_people_f.person_id%type
436: ,c_employee_type per_all_people_f.current_employee_flag%type
437: ,c_business_group_id hr_all_organization_units.organization_id%type
438: ,c_legal_employer pay_assignment_actions.tax_unit_id%type

Line 435: ,c_end_person per_all_people_f.person_id%type

431: --------------------------------------------------------------------+
432: cursor csr_assignment_paysum
433: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
434: ,c_start_person per_all_people_f.person_id%type
435: ,c_end_person per_all_people_f.person_id%type
436: ,c_employee_type per_all_people_f.current_employee_flag%type
437: ,c_business_group_id hr_all_organization_units.organization_id%type
438: ,c_legal_employer pay_assignment_actions.tax_unit_id%type
439: ,c_payroll_id varchar2

Line 436: ,c_employee_type per_all_people_f.current_employee_flag%type

432: cursor csr_assignment_paysum
433: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
434: ,c_start_person per_all_people_f.person_id%type
435: ,c_end_person per_all_people_f.person_id%type
436: ,c_employee_type per_all_people_f.current_employee_flag%type
437: ,c_business_group_id hr_all_organization_units.organization_id%type
438: ,c_legal_employer pay_assignment_actions.tax_unit_id%type
439: ,c_payroll_id varchar2
440: ,c_fin_year_start date

Line 508: ,c_start_person per_all_people_f.person_id%type

504: --------------------------------------------------------------------+
505:
506: cursor csr_assignment_only_paysum
507: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
508: ,c_start_person per_all_people_f.person_id%type
509: ,c_end_person per_all_people_f.person_id%type
510: ,c_employee_type per_all_people_f.current_employee_flag%type
511: ,c_business_group_id hr_all_organization_units.organization_id%type
512: ,c_legal_employer pay_assignment_actions.tax_unit_id%type

Line 509: ,c_end_person per_all_people_f.person_id%type

505:
506: cursor csr_assignment_only_paysum
507: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
508: ,c_start_person per_all_people_f.person_id%type
509: ,c_end_person per_all_people_f.person_id%type
510: ,c_employee_type per_all_people_f.current_employee_flag%type
511: ,c_business_group_id hr_all_organization_units.organization_id%type
512: ,c_legal_employer pay_assignment_actions.tax_unit_id%type
513: ,c_payroll_id varchar2

Line 510: ,c_employee_type per_all_people_f.current_employee_flag%type

506: cursor csr_assignment_only_paysum
507: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
508: ,c_start_person per_all_people_f.person_id%type
509: ,c_end_person per_all_people_f.person_id%type
510: ,c_employee_type per_all_people_f.current_employee_flag%type
511: ,c_business_group_id hr_all_organization_units.organization_id%type
512: ,c_legal_employer pay_assignment_actions.tax_unit_id%type
513: ,c_payroll_id varchar2
514: ,c_fin_year_start date

Line 587: ,c_employee_type per_all_people_f.current_employee_flag%type

583:
584: CURSOR csr_range_assignment_paysum
585: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
586: ,c_chunk NUMBER
587: ,c_employee_type per_all_people_f.current_employee_flag%type
588: ,c_business_group_id hr_all_organization_units.organization_id%type
589: ,c_legal_employer pay_assignment_actions.tax_unit_id%type
590: ,c_payroll_id varchar2
591: ,c_fin_year_start date