[Home] [Help]
382: is
383: select 1 from dual
384: where exists (
385: select 1
386: from pay_payroll_actions ppa
387: where ppa.business_group_id = cp_business_group_id
388: and ppa.action_type = 'X'
389: and ppa.report_type = cp_gre_type
390: and ppa.report_category in ('RM', 'RT')
536: from hr_assignment_set_amendments has,
537: per_assignments_f paf,
538: per_assignments_f paf1,
539: pay_assignment_actions paa,
540: pay_payroll_actions ppa,
541: pay_action_classifications pac
542: where has.assignment_set_id = cp_assign_set_id
543: and has.include_or_exclude = 'I'
544: and paf.assignment_id = has.assignment_id
565: or (ppa.action_type = 'V' and ppa.run_type_id is null
566: and paa.run_type_id is not null
567: and paa.source_action_id is null))
568: and not exists( SELECT 1
569: FROM pay_payroll_actions ppa1, -- Year End
570: pay_assignment_actions paa1 -- Year End
571: WHERE ppa1.report_type = 'YREND'
572: AND ppa1.action_status = 'C'
573: AND ppa1.effective_date = add_months(cp_effective_date, 12) - 1
588: cursor get_yepp_payroll_action(cp_effective_date date,
589: cp_gre_id number)
590: is
591: select payroll_action_id
592: from pay_payroll_actions
593: where action_type = 'X'
594: and action_status = 'C'
595: and report_type = 'YREND'
596: and pay_core_utils.get_parameter('TRANSFER_GRE',legislative_parameters) = cp_gre_id
615:
616: l_bal_aaid pay_assignment_actions.assignment_action_id%type;
617: l_assignment_id per_all_assignments_f.assignment_id%type;
618: l_person_id per_all_assignments_f.person_id%type;
619: l_yepp_payroll_action_id pay_payroll_actions.payroll_action_id%type;
620: l_value number;
621: lockingactid pay_assignment_actions.assignment_action_id%type;
622: l_prev_person_id per_all_assignments_f.person_id%type; -- bug 3315082
623:
835: and paf.assignment_id = has.assignment_id
836: and paf.primary_flag = 'Y'
837: and exists
838: ( select '1'
839: FROM pay_payroll_actions ppa, -- Year End
840: pay_assignment_actions paa -- Year End
841: WHERE ppa.report_type = 'YREND'
842: AND ppa.action_status = 'C'
843: AND ppa.effective_date = add_months(cp_effective_date, 12) - 1
856: per_assignments_f paf
857: where has.assignment_set_id = cp_assignment_set_id
858: and paf.assignment_id = has.assignment_id
859: and exists( SELECT 1
860: FROM pay_payroll_actions ppa1, -- Year End
861: pay_assignment_actions paa1 -- Year End
862: WHERE ppa1.report_type = 'YREND'
863: AND ppa1.action_status = 'C'
864: AND ppa1.effective_date = add_months(cp_effective_date, 12) - 1