DBA Data[Home] [Help]

APPS.PER_BPA_BUS dependencies on PER_ALL_ASSIGNMENTS_F

Line 376: FROM per_all_assignments_f

372: IS
373: --
374: CURSOR csr_get_asg_dates IS
375: SELECT effective_start_date, effective_end_date
376: FROM per_all_assignments_f
377: WHERE assignment_id = p_assignment_id
378: AND p_effective_date BETWEEN
379: effective_start_date and effective_end_date;
380: --

Line 499: FROM per_all_assignments_f

495: WHERE payroll_run_id = p_payroll_run_id;
496: --
497: CURSOR csr_get_assignment_bg IS
498: SELECT business_group_id
499: FROM per_all_assignments_f
500: WHERE assignment_id = p_assignment_id
501: AND p_effective_date BETWEEN
502: effective_start_date AND effective_end_date;
503: --