[Home] [Help]
963: from per_all_assignments_f paaf,
964: per_all_people_f ppf,
965: pay_all_payrolls_f papf,
966: pay_payroll_actions ppa,
967: hr_soft_coding_keyflex scl
968: where paaf.business_group_id = '|| g_business_group_id
969: ||' and papf.business_group_id = paaf.business_group_id '
970: ||' and paaf.effective_start_date <= '||''''||g_qtr_end_date||''''
971: ||' and paaf.effective_end_date >= '||''''||g_qtr_start_date||''''
2680: paaf.assignment_id
2681: from
2682: per_all_assignments_f paaf,
2683: pay_all_payrolls_f papf,
2684: hr_soft_coding_keyflex scl
2685: where
2686: paaf.business_group_id = g_business_group_id
2687: and paaf.payroll_id is not null
2688: and paaf.payroll_id = nvl(g_payroll_id,paaf.payroll_id)
2791: paaf.assignment_id
2792: from
2793: per_all_assignments_f paaf,
2794: pay_all_payrolls_f papf,
2795: hr_soft_coding_keyflex scl
2796: where
2797: paaf.business_group_id = g_business_group_id
2798: and paaf.payroll_id is not null
2799: and paaf.payroll_id = nvl(g_payroll_id,paaf.payroll_id)
2904: pps.period_of_service_id
2905: from
2906: per_all_assignments_f paaf,
2907: pay_all_payrolls_f papf,
2908: hr_soft_coding_keyflex scl,
2909: per_periods_of_service pps
2910: where
2911: paaf.business_group_id = g_business_group_id
2912: and paaf.payroll_id is not null
2995: select distinct papf.payroll_id
2996: from
2997: per_all_assignments_f paaf,
2998: pay_all_payrolls_f papf,
2999: hr_soft_coding_keyflex scl
3000: where
3001: paaf.business_group_id = g_business_group_id
3002: and paaf.payroll_id is not null
3003: and paaf.payroll_id = nvl(g_payroll_id,paaf.payroll_id)
3048: paaf.assignment_id
3049: from
3050: per_all_assignments_f paaf,
3051: pay_all_payrolls_f papf,
3052: hr_soft_coding_keyflex scl
3053: where
3054: paaf.business_group_id = g_business_group_id
3055: and paaf.payroll_id is not null
3056: and paaf.payroll_id = p_payroll_id