APPS.PAY_AU_PAYMENT_SUMMARY_AMEND dependencies on PER_ALL_ASSIGNMENTS_F

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

246: v_multiple_flag VARCHAR2(50);
247:
248: l_procedure VARCHAR2(80);
249:
250: CURSOR get_params(c_payroll_action_id per_all_assignments_f.assignment_id%TYPE)
251: IS
252: SELECT to_date('01-07-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') Financial_year_start
253: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),6,4),'DD-MM-YYYY') Financial_year_end
254: ,to_date('01-04-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') FBT_year_start

Line 271: ,c_assignment_id IN per_all_assignments_f.assignment_id%TYPE

267:
268: CURSOR process_assignments_only(c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE
269: ,c_start_person_id IN per_all_people_f.person_id%TYPE
270: ,c_end_person_id IN per_all_people_f.person_id%TYPE
271: ,c_assignment_id IN per_all_assignments_f.assignment_id%TYPE
272: ,c_financial_year IN VARCHAR2
273: ,c_tax_unit_id IN pay_assignment_actions.tax_unit_iD%TYPE)
274: IS
275: SELECT DISTINCT paf.assignment_id

Line 317: ,c_assignment_id IN per_all_assignments_f.assignment_id%TYPE

313: /* 14621185 - new cursor for multiple amended without checking the previous AU_PAY_SUMM_AMEND */
314: CURSOR multi_assignments_only(c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE
315: ,c_start_person_id IN per_all_people_f.person_id%TYPE
316: ,c_end_person_id IN per_all_people_f.person_id%TYPE
317: ,c_assignment_id IN per_all_assignments_f.assignment_id%TYPE
318: ,c_financial_year IN VARCHAR2
319: ,c_tax_unit_id IN pay_assignment_actions.tax_unit_iD%TYPE)
320: IS
321: SELECT DISTINCT paf.assignment_id

Line 457: from per_all_assignments_f pa2

453: AND has.assignment_set_id = c_assignment_set_id
454: AND upper(has.include_or_exclude) = 'I'
455: and not exists(
456: select null
457: from per_all_assignments_f pa2
458: where pa2.assignment_id = has.assignment_id
459: and pa2.effective_start_date > paf.effective_start_date)
460: AND EXISTS (
461: /* Check if a Datafile is run for this year */

Line 524: from per_all_assignments_f pa2

520: AND has.assignment_set_id = c_assignment_set_id
521: AND upper(has.include_or_exclude) = 'I'
522: and not exists(
523: select null
524: from per_all_assignments_f pa2
525: where pa2.assignment_id = has.assignment_id
526: and pa2.effective_start_date > paf.effective_start_date)
527: AND EXISTS (
528: /* Check if a Datafile is run for this year */