APPS.PQP_NL_PENSION_EXTRACTS dependencies on PER_BUSINESS_GROUPS

Line 2127: l_legislation_code per_business_groups.legislation_code%TYPE;

2123: l_balance_amount NUMBER :=0;
2124: l_bal_total_amt NUMBER :=0;
2125: l_dimension_name VARCHAR2(100);
2126: i per_all_assignments_f.business_group_id%TYPE;
2127: l_legislation_code per_business_groups.legislation_code%TYPE;
2128: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
2129: l_index NUMBER;
2130:
2131: BEGIN

Line 5712: FROM per_business_groups_perf pbg

5708: --
5709: CURSOR csr_leg_code (c_business_group_id IN Number) IS
5710: SELECT pbg.legislation_code
5711: ,pbg.currency_code
5712: FROM per_business_groups_perf pbg
5713: WHERE pbg.business_group_id = c_business_group_id;
5714: --
5715: -- Cursor to Check if a org hierarchy is attached to the BG.
5716: -- If it is attached get the valid version as of the effective date.