APPS.PER_NL_FDR_ARCHIVE dependencies on PER_BUSINESS_GROUPS

Line 1021: l_bg_name per_business_groups.NAME%TYPE;

1017:
1018: v_csr_get_peit csr_get_peit%rowtype;
1019:
1020: l_report_date VARCHAR2(100);
1021: l_bg_name per_business_groups.NAME%TYPE;
1022: l_bg_id NUMBER;
1023: l_msg_id VARCHAR2(100);
1024: l_tax_reg_num VARCHAR2(100);
1025: l_hire_date DATE;

Line 1376: FROM per_business_groups pbg

1372: PER_NL_FDR_ARCHIVE.get_all_parameters(p_actid, l_report_date, l_org_struct_id, l_person_id, l_org_id, l_bg_id);
1373:
1374: SELECT pbg.name
1375: INTO l_bg_name
1376: FROM per_business_groups pbg
1377: WHERE pbg.business_group_id = l_bg_id;
1378:
1379: IF l_person_id is NULL and l_org_id is NULL and l_org_struct_id is not NULL THEN
1380: