APPS.PAY_NL_WTS_REPORT dependencies on PER_BUSINESS_GROUPS

Line 495: SELECT name FROM per_business_groups

491: v_csr_get_wts_elements csr_get_wts_elements%ROWTYPE;
492: v_csr_get_retro_wts_elements csr_get_retro_wts_elements%ROWTYPE;
493:
494: CURSOR csr_get_bg_name(l_bg_id IN NUMBER) is
495: SELECT name FROM per_business_groups
496: WHERE
497: BUSINESS_GROUP_ID = l_bg_id;
498:
499: vCtr NUMBER := 0;

Line 500: l_bg_name per_business_groups.NAME%TYPE;

496: WHERE
497: BUSINESS_GROUP_ID = l_bg_id;
498:
499: vCtr NUMBER := 0;
500: l_bg_name per_business_groups.NAME%TYPE;
501: l_asg_act_id NUMBER;
502: l_rp_tot_ed_subsidy NUMBER;
503: l_rp_tot_lw_subsidy NUMBER;
504: l_rp_tot_ltu_subsidy NUMBER;

Line 1110: SELECT name FROM per_business_groups

1106: v_csr_get_wts_elements csr_get_wts_elements%ROWTYPE;
1107: v_csr_get_retro_wts_elements csr_get_retro_wts_elements%ROWTYPE;
1108:
1109: CURSOR csr_get_bg_name(l_bg_id IN NUMBER) is
1110: SELECT name FROM per_business_groups
1111: WHERE
1112: BUSINESS_GROUP_ID = l_bg_id;
1113:
1114: vCtr NUMBER := 0;

Line 1115: l_bg_name per_business_groups.NAME%TYPE;

1111: WHERE
1112: BUSINESS_GROUP_ID = l_bg_id;
1113:
1114: vCtr NUMBER := 0;
1115: l_bg_name per_business_groups.NAME%TYPE;
1116: l_asg_act_id NUMBER;
1117: l_rp_tot_ed_subsidy NUMBER;
1118: l_rp_tot_lw_subsidy NUMBER;
1119: l_rp_tot_ltu_subsidy NUMBER;