DBA Data[Home] [Help]

APPS.PAY_JP_LTAX_IMP_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 792: per_periods_of_service ppos,

788: hr_all_organization_units hou,
789: pay_jp_swot_numbers pjsn_act,
790: pay_jp_swot_numbers pjsn_rep,
791: per_addresses pad,
792: per_periods_of_service ppos,
793: per_all_assignments_f pa,
794: per_time_periods ptp
795: where hoi.org_information_context = 'CLASS'
796: and hoi.org_information1 = 'JP_TAX_SWOT'

Line 1465: per_periods_of_service ppos

1461: greatest(ppos.actual_termination_date,nvl(ppos.final_process_date,ppos.actual_termination_date)) final_process_date
1462: from per_all_people_f pp,
1463: per_all_assignments_f pa,
1464: per_time_periods ptp,
1465: per_periods_of_service ppos
1466: where pp.business_group_id + 0 = g_business_group_id
1467: and pp.effective_start_date <= g_effective_eom
1468: and pp.effective_end_date >= g_effective_som
1469: and pp.employee_number = p_employee_number