[Home] [Help]
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'
797: and hoi.organization_id = nvl(g_organization_id,hoi.organization_id)
798: and hou.organization_id = hoi.organization_id
846: pa.assignment_number,
847: hasa.include_or_exclude
848: from hr_assignment_set_amendments hasa,
849: per_all_assignments_f pa,
850: per_time_periods ptp
851: where hasa.assignment_set_id = g_assignment_set_id
852: and pa.assignment_id = hasa.assignment_id
853: and pa.effective_start_date <= g_effective_eom
854: and pa.effective_end_date >= g_effective_som
1460: ptp.regular_payment_date,
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
2055: p_payroll_id in number)
2056: is
2057: select ptp.regular_payment_date payment_date,
2058: ptp.start_date upload_date
2059: from per_time_periods ptp
2060: where ptp.payroll_id = p_payroll_id
2061: and ptp.period_type = 'Calendar Month'
2062: and ptp.regular_payment_date >= g_effective_som
2063: and ptp.regular_payment_date < add_months(g_effective_som,12)