APPS.PAY_ZA_UIF_ARCHIVE_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 592: per_periods_of_service pds -- Bug 2654703

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

Line 655: ,per_periods_of_service pps

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

Line 903: l_date_employed_from per_periods_of_service.date_start%type;

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

Line 904: l_date_employed_to per_periods_of_service.actual_termination_date%type;

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

Line 905: l_leaving_reason per_periods_of_service.leaving_reason%type;

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

Line 918: per_periods_of_service pos

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

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

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