DBA Data[Home] [Help]

APPS.PER_PCL_BUS dependencies on PER_BUSINESS_GROUPS

Line 111: l_ccy_code per_business_groups.currency_code%TYPE;

107: l_date DATE;
108: l_value VARCHAR2(255);
109: l_output VARCHAR2(255);
110: l_rgeflg VARCHAR2(255);
111: l_ccy_code per_business_groups.currency_code%TYPE;
112: size_error EXCEPTION;
113: --
114: CURSOR csr_get_ccy_code IS
115: SELECT currency_code

Line 116: FROM per_business_groups

112: size_error EXCEPTION;
113: --
114: CURSOR csr_get_ccy_code IS
115: SELECT currency_code
116: FROM per_business_groups
117: WHERE business_group_id = p_business_group_id;
118: --
119: CURSOR csr_get_item_size IS
120: SELECT cap.column_size

Line 249: from per_business_groups pbg

245: -- Declare cursor
246: --
247: cursor csr_sec_grp is
248: select pbg.security_group_id
249: from per_business_groups pbg
250: , per_cagr_entitlement_lines_f pcl
251: , per_cagr_entitlements pce
252: , per_cagr_entitlement_items pci
253:

Line 317: from per_business_groups pbg

313: --
314:
315: cursor csr_leg_code is
316: select pbg.legislation_code
317: from per_business_groups pbg
318: , per_cagr_entitlement_lines_f pcl
319: , per_cagr_entitlements pce
320: , per_cagr_entitlement_items pci
321: