DBA Data[Home] [Help]

APPS.PER_AE_XDO_REPORT dependencies on PER_BUSINESS_GROUPS

Line 19: FROM per_business_groups

15: l_business_group_id NUMBER;
16: l_organization_id NUMBER;
17: CURSOR csr_get_bg_id IS
18: SELECT business_group_id
19: FROM per_business_groups
20: WHERE business_group_id = nvl(p_business_group_id, business_group_id)
21: AND legislation_code = 'AE';
22: rec_get_bg_id csr_get_bg_id%ROWTYPE;
23: CURSOR csr_get_org_id(c_business_group_id number) IS

Line 397: FROM per_business_groups

393: l_business_group_id NUMBER;
394: l_organization_id NUMBER;
395: CURSOR csr_get_bg_id IS
396: SELECT business_group_id
397: FROM per_business_groups
398: WHERE business_group_id = nvl(p_business_group_id, business_group_id)
399: AND legislation_code = 'AE';
400: rec_get_bg_id csr_get_bg_id%ROWTYPE;
401: CURSOR csr_get_org_id(c_business_group_id number) IS

Line 822: FROM per_business_groups

818: l_b_appdate varchar2(100);
819: l_b_edate varchar2(100);
820: CURSOR csr_get_bg_id IS
821: SELECT business_group_id
822: FROM per_business_groups
823: WHERE business_group_id = nvl(p_business_group_id, business_group_id)
824: AND legislation_code = 'AE';
825: rec_get_bg_id csr_get_bg_id%ROWTYPE;
826: CURSOR csr_get_org_id IS