DBA Data[Home] [Help]

APPS.PQP_NL_PGGM_PENSION_EXTRACTS dependencies on PAY_ALL_PAYROLLS_F

Line 3391: pay_all_payrolls_f ppf

3387: -- Cursor to get Org id for the given asg id
3388: CURSOR csr_get_org_id IS
3389: SELECT fnd_number.canonical_to_number (ppf.prl_information1)
3390: FROM per_all_assignments_f paf,
3391: pay_all_payrolls_f ppf
3392: WHERE paf.assignment_id = p_assignment_id
3393: AND paf.business_group_id = p_business_group_id
3394: AND g_extract_params(p_business_group_id).extract_end_date BETWEEN
3395: paf.effective_start_date AND paf.effective_end_date

Line 3470: pay_all_payrolls_f ppf

3466: -- Cursor to get Org id for the given asg id
3467: CURSOR csr_get_org_id IS
3468: SELECT fnd_number.canonical_to_number (ppf.prl_information1)
3469: FROM per_all_assignments_f paf,
3470: pay_all_payrolls_f ppf
3471: WHERE paf.assignment_id = p_assignment_id
3472: AND paf.business_group_id = p_business_group_id
3473: AND g_extract_params(p_business_group_id).extract_end_date BETWEEN
3474: paf.effective_start_date AND paf.effective_end_date