[Home] [Help]
448: AND paa_arch.tax_unit_id = g_mag_gre_id
449: /*AND NOT EXISTS (SELECT 'X'
450: FROM pay_payroll_actions ppa_sua,
451: pay_assignment_actions paa_sua,
452: pay_action_interlocks lck
453: WHERE lck.locked_action_id = pai.action_context_id
454: AND lck.locking_action_id =
455: paa_sua.assignment_action_id
456: AND paa_sua.payroll_action_id =
520: AND paa_arch.tax_unit_id = g_mag_gre_id
521: /*AND NOT EXISTS (SELECT 'X'
522: FROM pay_payroll_actions ppa_sua,
523: pay_assignment_actions paa_sua,
524: pay_action_interlocks lck
525: WHERE lck.locked_action_id = pai.action_context_id
526: AND lck.locking_action_id =
527: paa_sua.assignment_action_id
528: AND paa_sua.payroll_action_id =
559: ppa.legislative_parameters)) >
560: fnd_date.canonical_to_date(g_mag_end_date);
561:
562: /*Bug 8768679 - The following cursor has been added to find out if
563: the Archiver Assignment action has been already locked in pay_action_interlocks*/
564: CURSOR c_assg_action_exist (p_arch_asg_act NUMBER) IS
565: SELECT count(*)
566: FROM pay_action_interlocks
567: WHERE locked_action_id = p_arch_asg_act;
562: /*Bug 8768679 - The following cursor has been added to find out if
563: the Archiver Assignment action has been already locked in pay_action_interlocks*/
564: CURSOR c_assg_action_exist (p_arch_asg_act NUMBER) IS
565: SELECT count(*)
566: FROM pay_action_interlocks
567: WHERE locked_action_id = p_arch_asg_act;
568:
569: /*Bug 8768679 - The follwowing cursor has been added to find out if
570: the archiver assignment action has already been locked by another
572: CURSOR c_report_type (p_arch_asg_act NUMBER) IS
573: SELECT count(*)
574: FROM pay_payroll_actions pact,
575: pay_assignment_actions paa,
576: pay_action_interlocks pail
577: WHERE p_arch_asg_act = pail.locked_action_id
578: AND pail.locking_action_id = paa.assignment_action_id
579: AND paa.payroll_action_id = pact.payroll_action_id
580: AND pact.report_type = 'SUA_MAG';
780: nvl(pai.action_information21, 'N') -- Do not report flag
781: FROM pay_action_information pai,
782: pay_assignment_actions paa_arch,
783: per_all_assignments_f paf,
784: pay_action_interlocks lck
785: WHERE pai.action_context_id = paa_arch.assignment_action_id
786: AND paf.assignment_id = paa_arch.assignment_id
787: /*Bug 8768679*/
788: AND fnd_date.canonical_to_date(pai.action_information10)
811: pai.action_information24 -- Report Rehire Termination
812: FROM pay_action_information pai,
813: pay_assignment_actions paa_arch,
814: per_all_assignments_f paf,
815: pay_action_interlocks lck
816: WHERE pai.action_context_id = paa_arch.assignment_action_id
817: AND paf.assignment_id = paa_arch.assignment_id
818: --Bug 7185703
819: AND fnd_date.canonical_to_date (pai.action_information2) >= fnd_date.canonical_to_date(cp_imp_date)
856: pay_payroll_actions ppa_mag,
857: pay_assignment_actions paa_mag_prev,
858: pay_payroll_actions ppa_mag_prev,
859: pay_action_information pai,
860: pay_action_interlocks lck
861: WHERE paa_mag.payroll_action_id = ppa_mag.payroll_action_id
862: AND paa_mag_prev.payroll_action_id = ppa_mag_prev.payroll_action_id
863: AND pay_mx_utility.get_legi_param_val ('GRE',
864: ppa_mag.payroll_action_id) =
934: SELECT fnd_number.canonical_to_number(pai.action_information8)
935: FROM pay_payroll_actions ppa_sua,
936: pay_assignment_actions paa_sua,
937: pay_assignment_actions paa_arch,
938: pay_action_interlocks lck,
939: pay_action_information pai
940: WHERE ppa_sua.payroll_action_id = paa_sua.payroll_action_id
941: AND paa_sua.assignment_action_id = lck.locking_action_id
942: AND lck.locked_action_id = paa_arch.assignment_action_id
1329: CURSOR get_arch_pact_id (cp_chunk NUMBER) IS
1330: SELECT DISTINCT paa_arch.payroll_action_id
1331: FROM pay_assignment_actions paa_arch,
1332: pay_assignment_actions paa_mag,
1333: pay_action_interlocks lck
1334: WHERE paa_arch.assignment_action_id = lck.locked_action_id
1335: AND lck.locking_action_id = paa_mag.assignment_action_id
1336: AND paa_mag.chunk_number >= cp_chunk
1337: AND paa_mag.payroll_action_id =