DBA Data[Home] [Help]

APPS.PAY_AU_TFN_MAGTAPE dependencies on PER_ALL_PEOPLE_F

Line 100: p_start_person_id in per_all_people_f.person_id%TYPE,

96: ----------------------------------------------------------------------------+
97:
98: PROCEDURE assignment_action_code
99: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE,
100: p_start_person_id in per_all_people_f.person_id%TYPE,
101: p_END_person_id in per_all_people_f.person_id%TYPE,
102: p_chunk in number) IS
103:
104: v_next_action_id pay_assignment_actions.assignment_action_id%TYPE;

Line 101: p_END_person_id in per_all_people_f.person_id%TYPE,

97:
98: PROCEDURE assignment_action_code
99: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE,
100: p_start_person_id in per_all_people_f.person_id%TYPE,
101: p_END_person_id in per_all_people_f.person_id%TYPE,
102: p_chunk in number) IS
103:
104: v_next_action_id pay_assignment_actions.assignment_action_id%TYPE;
105: v_run_action_id pay_assignment_actions.assignment_action_id%TYPE;

Line 135: c_start_person_id in per_all_people_f.person_id%TYPE,

131: and condition
132: paa.effective_start_date between c_report_end_date - 13 and c_report_end_date */
133: CURSOR process_assignments
134: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE,
135: c_start_person_id in per_all_people_f.person_id%TYPE,
136: c_end_person_id in per_all_people_f.person_id%TYPE,
137: c_business_group_id in per_business_groups.business_group_id%TYPE,
138: c_legal_employer_id in hr_soft_coding_keyflex.segment1%TYPE,
139: c_report_end_date in date) IS

Line 136: c_end_person_id in per_all_people_f.person_id%TYPE,

132: paa.effective_start_date between c_report_end_date - 13 and c_report_end_date */
133: CURSOR process_assignments
134: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE,
135: c_start_person_id in per_all_people_f.person_id%TYPE,
136: c_end_person_id in per_all_people_f.person_id%TYPE,
137: c_business_group_id in per_business_groups.business_group_id%TYPE,
138: c_legal_employer_id in hr_soft_coding_keyflex.segment1%TYPE,
139: c_report_end_date in date) IS
140: SELECT /*+ ORDERED */ paa.assignment_id,