APPS.PAY_AU_PAYMENT_SUMMARY_AMEND dependencies on PER_ALL_ASSIGNMENTS_F

Line 171: CURSOR get_params(c_payroll_action_id per_all_assignments_f.assignment_id%TYPE)

167: v_assignment_set_id VARCHAR2(50);
168:
169: l_procedure VARCHAR2(80);
170:
171: CURSOR get_params(c_payroll_action_id per_all_assignments_f.assignment_id%TYPE)
172: IS
173: SELECT to_date('01-07-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') Financial_year_start
174: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),6,4),'DD-MM-YYYY') Financial_year_end
175: ,to_date('01-04-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') FBT_year_start

Line 191: ,c_assignment_id IN per_all_assignments_f.assignment_id%TYPE

187:
188: CURSOR process_assignments_only(c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE
189: ,c_start_person_id IN per_all_people_f.person_id%TYPE
190: ,c_end_person_id IN per_all_people_f.person_id%TYPE
191: ,c_assignment_id IN per_all_assignments_f.assignment_id%TYPE
192: ,c_financial_year IN VARCHAR2
193: ,c_tax_unit_id IN pay_assignment_actions.tax_unit_iD%TYPE)
194: IS
195: SELECT DISTINCT paf.assignment_id