[Home] [Help]
789: from per_all_assignments_f paaf,
790: per_all_people_f ppf,
791: pay_all_payrolls_f papf,
792: pay_payroll_actions ppa,
793: hr_soft_coding_keyflex scl
794: where paaf.business_group_id = '|| g_business_group_id
795: ||' and papf.business_group_id = paaf.business_group_id '
796: ||' and paaf.effective_start_date <= '||''''||g_qtr_end_date||''''
797: ||' and paaf.effective_end_date >= '||''''||g_qtr_start_date||''''
2397: paaf.assignment_id
2398: from
2399: per_all_assignments_f paaf,
2400: pay_all_payrolls_f papf,
2401: hr_soft_coding_keyflex scl
2402: where
2403: paaf.business_group_id = g_business_group_id
2404: and paaf.payroll_id is not null
2405: and paaf.payroll_id = nvl(g_payroll_id,paaf.payroll_id)
2506: paaf.assignment_id
2507: from
2508: per_all_assignments_f paaf,
2509: pay_all_payrolls_f papf,
2510: hr_soft_coding_keyflex scl
2511: where
2512: paaf.business_group_id = g_business_group_id
2513: and paaf.payroll_id is not null
2514: and paaf.payroll_id = nvl(g_payroll_id,paaf.payroll_id)
2617: pps.period_of_service_id
2618: from
2619: per_all_assignments_f paaf,
2620: pay_all_payrolls_f papf,
2621: hr_soft_coding_keyflex scl,
2622: per_periods_of_service pps
2623: where
2624: paaf.business_group_id = g_business_group_id
2625: and paaf.payroll_id is not null
2708: select distinct papf.payroll_id
2709: from
2710: per_all_assignments_f paaf,
2711: pay_all_payrolls_f papf,
2712: hr_soft_coding_keyflex scl
2713: where
2714: paaf.business_group_id = g_business_group_id
2715: and paaf.payroll_id is not null
2716: and paaf.payroll_id = nvl(g_payroll_id,paaf.payroll_id)
2761: paaf.assignment_id
2762: from
2763: per_all_assignments_f paaf,
2764: pay_all_payrolls_f papf,
2765: hr_soft_coding_keyflex scl
2766: where
2767: paaf.business_group_id = g_business_group_id
2768: and paaf.payroll_id is not null
2769: and paaf.payroll_id = p_payroll_id