422: v_csr_get_wts_elements csr_get_wts_elements%ROWTYPE;
423: v_csr_get_retro_wts_elements csr_get_retro_wts_elements%ROWTYPE;
424:
425: CURSOR csr_get_bg_name(l_bg_id IN NUMBER) is
426: SELECT name FROM per_business_groups
427: WHERE
428: BUSINESS_GROUP_ID = l_bg_id;
429:
430: vCtr NUMBER := 0;
427: WHERE
428: BUSINESS_GROUP_ID = l_bg_id;
429:
430: vCtr NUMBER := 0;
431: l_bg_name per_business_groups.NAME%TYPE;
432: l_asg_act_id NUMBER;
433: l_rp_tot_ed_subsidy NUMBER;
434: l_rp_tot_lw_subsidy NUMBER;
435: l_rp_tot_ltu_subsidy NUMBER;
1028: v_csr_get_wts_elements csr_get_wts_elements%ROWTYPE;
1029: v_csr_get_retro_wts_elements csr_get_retro_wts_elements%ROWTYPE;
1030:
1031: CURSOR csr_get_bg_name(l_bg_id IN NUMBER) is
1032: SELECT name FROM per_business_groups
1033: WHERE
1034: BUSINESS_GROUP_ID = l_bg_id;
1035:
1036: vCtr NUMBER := 0;
1033: WHERE
1034: BUSINESS_GROUP_ID = l_bg_id;
1035:
1036: vCtr NUMBER := 0;
1037: l_bg_name per_business_groups.NAME%TYPE;
1038: l_asg_act_id NUMBER;
1039: l_rp_tot_ed_subsidy NUMBER;
1040: l_rp_tot_lw_subsidy NUMBER;
1041: l_rp_tot_ltu_subsidy NUMBER;