APPS.PAY_SIMULATOR_PKG dependencies on PER_BUSINESS_GROUPS_PERF

Line 500: v_legislation per_business_groups_perf.legislation_code%TYPE;

496: v_inp_val_id VARCHAR2(40);
497: v_exists BOOLEAN;
498: scr_valuetbl hr_entry.varchar2_table;
499: inp_value_id_tbl hr_entry.number_table;
500: v_legislation per_business_groups_perf.legislation_code%TYPE;
501:
502: v_sim_region3 VARCHAR2(30);
503: v_sim_region4 VARCHAR2(30);
504: lv_procedure_name VARCHAR2(100) := '.update_element_entries';

Line 558: per_business_groups_perf pbg

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
562: ;

Line 747: l_legislation per_business_groups_perf.legislation_code%TYPE;

743: v_period_end_date DATE;
744: sql_cursor INTEGER;
745: l_rows INTEGER;
746: preprocess_statement VARCHAR2(2000);
747: l_legislation per_business_groups_perf.legislation_code%TYPE;
748: l_bg_id NUMBER;
749: ecode VARCHAR2(50);
750: emesg VARCHAR2(2000);
751: lv_procedure_name VARCHAR2(100) := '.simulator_preprocessing';

Line 771: per_business_groups_perf pbg

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
775: ;

Line 883: l_legislation per_business_groups_perf.legislation_code%TYPE;

879: l_rows INTEGER;
880: preprocess_statement VARCHAR2(2000);
881: ecode VARCHAR2(50);
882: emesg VARCHAR2(2000);
883: l_legislation per_business_groups_perf.legislation_code%TYPE;
884: n_assact_id NUMBER;
885: lv_procedure_name VARCHAR2(100) := '.archive_run_results';
886:
887: CURSOR run_results (v_assact_id NUMBER) IS

Line 960: per_business_groups_perf pbg

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
964: ;