APPS.PQP_NL_PENSION_EXTRACTS dependencies on PER_BUSINESS_GROUPS

Line 2106: l_legislation_code per_business_groups.legislation_code%TYPE;

2102: l_balance_amount NUMBER :=0;
2103: l_bal_total_amt NUMBER :=0;
2104: l_dimension_name VARCHAR2(100);
2105: i per_all_assignments_f.business_group_id%TYPE;
2106: l_legislation_code per_business_groups.legislation_code%TYPE;
2107: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
2108: l_index NUMBER;
2109:
2110: BEGIN

Line 5523: FROM per_business_groups_perf pbg

5519: --
5520: CURSOR csr_leg_code (c_business_group_id IN Number) IS
5521: SELECT pbg.legislation_code
5522: ,pbg.currency_code
5523: FROM per_business_groups_perf pbg
5524: WHERE pbg.business_group_id = c_business_group_id;
5525: --
5526: -- Cursor to Check if a org hierarchy is attached to the BG.
5527: -- If it is attached get the valid version as of the effective date.