[Home] [Help]
412: -- Cursor to get person_id of the assignments selected
413: cursor c_person_id (cp_assign_id number)
414: is
415: select person_id
416: from per_assignments_f
417: where assignment_id=cp_assign_id;
418:
419: -- Cursor to get Employee details
420: cursor c_employee_details (cp_person_id number )
533: select /*+ ORDERED */max(paa.assignment_action_id),
534: paf1.assignment_id,
535: paf.person_id
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
534: paf1.assignment_id,
535: paf.person_id
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
829: cp_assignment_set_id number)
830: is
831: select distinct has.assignment_id
832: from hr_assignment_set_amendments has,
833: per_assignments_f paf
834: where has.assignment_set_id = cp_assignment_set_id
835: and paf.assignment_id = has.assignment_id
836: and paf.primary_flag = 'Y'
837: and exists
852: cp_assignment_set_id number)
853: is
854: select distinct has.assignment_id
855: from hr_assignment_set_amendments has,
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
867: length('TRANSFER_GRE='))) = cp_gre_id -- Bug 3228332
868: AND ppa1.payroll_action_id = paa1.payroll_action_id
869: AND paa1.serial_number = to_char(paf.person_id)); -- Bug 3228332
870:
871: l_processed_assignment_id per_assignments_f.assignment_id%type;
872:
873: BEGIN
874:
875: hr_utility.set_location(gv_package_name || '.get_processed_assignments', 10);
917: cp_effective_date date)
918: is
919: select distinct has.assignment_id
920: from hr_assignment_set_amendments has,
921: per_assignments_f paf,
922: pay_us_asg_reporting puar
923: where has.assignment_set_id = cp_assignment_set_id
924: and paf.assignment_id = has.assignment_id
925: and nvl(has.include_or_exclude,'I') = 'I'
928: and puar.assignment_id = paf.assignment_id
929: and puar.tax_unit_id = cp_gre_id
930: and paf.primary_flag = 'Y';
931:
932: l_assignment_id per_assignments_f.assignment_id%type;
933:
934: BEGIN
935:
936: hr_utility.set_location(gv_package_name || '.get_non_elgble_assignments', 10);
1032: cp_effective_date date)
1033: is
1034: select distinct has.assignment_id
1035: from hr_assignment_set_amendments has,
1036: per_assignments_f paf,
1037: pay_us_asg_reporting puar
1038: where assignment_set_id = cp_assignment_set_id
1039: and paf.assignment_id = has.assignment_id
1040: and nvl(has.include_or_exclude,'I') = 'I'
1043: and puar.assignment_id = paf.assignment_id
1044: and puar.tax_unit_id = cp_gre_id
1045: and paf.primary_flag <> 'Y';
1046:
1047: l_assignment_id per_assignments_f.assignment_id%type;
1048: l_count number := 0;
1049: l_header_printed varchar2(1) := 'N';
1050: BEGIN
1051:
1131: cp_effective_date date)
1132: is
1133: select distinct has.assignment_id, puar.tax_unit_id
1134: from hr_assignment_set_amendments has,
1135: per_assignments_f paf,
1136: pay_us_asg_reporting puar
1137: where assignment_set_id = cp_assignment_set_id
1138: and paf.assignment_id = has.assignment_id
1139: and nvl(has.include_or_exclude,'I') = 'I'
1148: select name
1149: from hr_organization_units
1150: where organization_id = cp_gre_id;
1151:
1152: l_oth_assignment_id per_assignments_f.assignment_id%type;
1153: l_gre_id pay_us_asg_reporting.tax_unit_id%type;
1154: l_header_printed varchar2(1) := 'N';
1155:
1156: BEGIN