APPS.PAY_ZA_UIF_ARCHIVE_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 593: per_periods_of_service pds -- Bug 2654703

589: per_assignments_f asg3,
590: --pay_payrolls_f ppf, -- Bug 2608190
591: pay_payroll_actions ppa_arch,
592: per_assignment_extra_info paei,
593: per_periods_of_service pds -- Bug 2654703
594: where asg.business_group_id = ppa_arch.business_group_id
595: and asg.period_of_service_id = pds.period_of_service_id -- Bug 2608190
596: and asg3.period_of_service_id = pds.period_of_service_id -- Bug 2608190
597: and asg.person_id between p_stperson and p_endperson

Line 656: ,per_periods_of_service pps

652: from per_all_people_f ppf
653: ,per_all_assignments_f paa
654: ,per_assignment_extra_info paei
655: ,pay_payroll_actions ppa_arch
656: ,per_periods_of_service pps
657: where paa.business_group_id = ppa_arch.business_group_id
658: and paa.person_id = ppf.person_id
659: and ppf.person_id between p_stperson and p_endperson /* to select all Employees in a payroll run */
660: and paa.period_of_service_id = pps.period_of_service_id

Line 904: l_date_employed_from per_periods_of_service.date_start%type;

900: l_employee_number per_people_f.employee_number%type;
901: l_last_name per_people_f.last_name%type;
902: l_first_names varchar2(600);
903: l_date_of_birth per_people_f.date_of_birth%type;
904: l_date_employed_from per_periods_of_service.date_start%type;
905: l_date_employed_to per_periods_of_service.actual_termination_date%type;
906: l_leaving_reason per_periods_of_service.leaving_reason%type;
907:
908: cursor csr_employee_data (p_person_id number, p_eff_date date) is

Line 905: l_date_employed_to per_periods_of_service.actual_termination_date%type;

901: l_last_name per_people_f.last_name%type;
902: l_first_names varchar2(600);
903: l_date_of_birth per_people_f.date_of_birth%type;
904: l_date_employed_from per_periods_of_service.date_start%type;
905: l_date_employed_to per_periods_of_service.actual_termination_date%type;
906: l_leaving_reason per_periods_of_service.leaving_reason%type;
907:
908: cursor csr_employee_data (p_person_id number, p_eff_date date) is
909: select per.national_identifier ID_Number,

Line 906: l_leaving_reason per_periods_of_service.leaving_reason%type;

902: l_first_names varchar2(600);
903: l_date_of_birth per_people_f.date_of_birth%type;
904: l_date_employed_from per_periods_of_service.date_start%type;
905: l_date_employed_to per_periods_of_service.actual_termination_date%type;
906: l_leaving_reason per_periods_of_service.leaving_reason%type;
907:
908: cursor csr_employee_data (p_person_id number, p_eff_date date) is
909: select per.national_identifier ID_Number,
910: nvl(per.per_information2, per.per_information3) Other_Number,

Line 919: per_periods_of_service pos

915: pos.date_start Date_Employed_From,
916: pos.actual_termination_date Date_Employed_To,
917: pos.leaving_reason
918: from per_people_f per,
919: per_periods_of_service pos
920: where per.person_id = p_person_id
921: -- Bug 4306265: and per.effective_end_date between per.effective_start_date and p_eff_date -- Modified the condition for Bug : 3869426
922: and p_eff_date between per.effective_start_date and per.effective_end_date -- Bug 4306265: re-enabled /* Old Condition Before Bug : 3869426 */
923: and per.per_information_category = 'ZA'

Line 1217: --by using the mapping for LEAV_REAS (from per_periods_of_service.leaving_reason)

1213:
1214:
1215: --IF l_date_employed_to IS NOT NULL then get the value for l_empl_status from
1216: --the ZA_TERMINATION_CATEGORIES User Table, column UIF Employment Status,
1217: --by using the mapping for LEAV_REAS (from per_periods_of_service.leaving_reason)
1218: if (l_date_employed_to is not null and l_date_employed_to <> to_date('31/12/4712', 'DD/MM/YYYY'))
1219: then
1220:
1221: --Get the Lookup Meaning for the LEAV_REAS Lookup Code in l_leaving_reason