DBA Data[Home] [Help]

APPS.PAY_SIMULATOR_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 557: FROM per_all_assignments_f paf,

553:
554: SELECT /*+ INDEX(paf PER_ASSIGNMENTS_F_PK)*/
555: pbg.legislation_code
556: INTO v_legislation
557: FROM per_all_assignments_f paf,
558: per_business_groups_perf pbg
559: WHERE paf.assignment_id = p_assignment_id
560: AND p_period_end_date BETWEEN paf.effective_start_date AND paf.effective_end_date
561: AND paf.business_group_id = pbg.business_group_id

Line 770: FROM per_all_assignments_f paf,

766: pbg.legislation_code
767: ,paf.business_group_id
768: INTO l_legislation
769: ,l_bg_id
770: FROM per_all_assignments_f paf,
771: per_business_groups_perf pbg
772: WHERE paf.assignment_id = v_ass_id
773: AND v_period_end_date BETWEEN paf.effective_start_date AND paf.effective_end_date
774: AND paf.business_group_id = pbg.business_group_id

Line 959: FROM per_all_assignments_f paf,

955:
956: SELECT /*+ INDEX(paf PER_ASSIGNMENTS_F_PK)*/
957: pbg.legislation_code
958: INTO l_legislation
959: FROM per_all_assignments_f paf,
960: per_business_groups_perf pbg
961: WHERE paf.assignment_id = v_ass_id
962: AND v_period_end_date BETWEEN paf.effective_start_date AND paf.effective_end_date
963: AND paf.business_group_id = pbg.business_group_id