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 137: c_start_person_id in per_all_people_f.person_id%TYPE,

133: /* Bug 8352719 - Removed NULL termination date check at 2 places and a redundant join*/
134: /* Bug 12377615- Changed to STAR_TRANSFORMATION hint from ORDERED */
135: CURSOR process_assignments
136: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE,
137: c_start_person_id in per_all_people_f.person_id%TYPE,
138: c_end_person_id in per_all_people_f.person_id%TYPE,
139: c_business_group_id in per_business_groups.business_group_id%TYPE,
140: c_legal_employer_id in hr_soft_coding_keyflex.segment1%TYPE,
141: c_report_end_date in date) IS

Line 138: c_end_person_id in per_all_people_f.person_id%TYPE,

134: /* Bug 12377615- Changed to STAR_TRANSFORMATION hint from ORDERED */
135: CURSOR process_assignments
136: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE,
137: c_start_person_id in per_all_people_f.person_id%TYPE,
138: c_end_person_id in per_all_people_f.person_id%TYPE,
139: c_business_group_id in per_business_groups.business_group_id%TYPE,
140: c_legal_employer_id in hr_soft_coding_keyflex.segment1%TYPE,
141: c_report_end_date in date) IS
142: SELECT /*+ STAR_TRANSFORMATION */ paa.assignment_id,