APPS.PQP_US_PENSION_EXTRACTS dependencies on PER_BUSINESS_GROUPS

Line 46: FROM per_business_groups_perf pbg

42: -- =============================================================================
43: CURSOR csr_leg_code (c_business_group_id IN NUMBER) IS
44: SELECT pbg.legislation_code
45: ,pbg.currency_code
46: FROM per_business_groups_perf pbg
47: WHERE pbg.business_group_id = c_business_group_id;
48:
49: -- =============================================================================
50: -- Cursor to get assignment details

Line 1331: l_legislation_code per_business_groups.legislation_code%TYPE;

1327: l_element_name pay_element_types_f.element_name%TYPE;
1328: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
1329: l_balance_name pay_balance_types.balance_name%TYPE;
1330: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
1331: l_legislation_code per_business_groups.legislation_code%TYPE;
1332: l_info_category pay_element_types_f.element_information_category%TYPE;
1333: l_pretax_category pay_element_types_f.element_information1%TYPE;
1334: l_proc_name VARCHAR2(150) := g_proc_name ||'Get_Element_Info';
1335: l_ele_info_rec csr_ele_info%ROWTYPE;

Line 1605: l_legislation_code per_business_groups.legislation_code%TYPE;

1601: l_element_name pay_element_types_f.element_name%TYPE;
1602: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
1603: l_balance_name pay_balance_types.balance_name%TYPE;
1604: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
1605: l_legislation_code per_business_groups.legislation_code%TYPE;
1606: l_proc_name VARCHAR2(150) := g_proc_name ||'Get_Element_Info';
1607: l_ele_info_rec csr_ele_info%ROWTYPE;
1608: BEGIN
1609: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

Line 4147: l_legislation_code per_business_groups.legislation_code%TYPE;

4143: l_balance_amount NUMBER;
4144: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
4145: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
4146: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;
4147: l_legislation_code per_business_groups.legislation_code%TYPE;
4148: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
4149: i per_all_assignments_f.business_group_id%TYPE;
4150: l_valid_action VARCHAR2(2);
4151: l_proc_name VARCHAR2(150) := g_proc_name ||'Get_Deduction_Amount';

Line 4333: l_legislation_code per_business_groups.legislation_code%TYPE;

4329: l_effective_date DATE;
4330: l_return_value VARCHAR2(50) := '0';
4331: l_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
4332: l_error_message VARCHAR2(3000);
4333: l_legislation_code per_business_groups.legislation_code%TYPE;
4334: l_index NUMBER :=0;
4335: l_proc_name VARCHAR2(150) := g_proc_name ||'Get_Element_Entry_Value';
4336:
4337: BEGIN

Line 4425: l_legislation_code per_business_groups.legislation_code%TYPE;

4421: l_balance_amount NUMBER :=0;
4422: l_bal_total_amt NUMBER :=0;
4423: l_dimension_name pay_balance_dimensions.dimension_name%TYPE;
4424: i per_all_assignments_f.business_group_id%TYPE;
4425: l_legislation_code per_business_groups.legislation_code%TYPE;
4426: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
4427: l_balance_dimension_id pay_balance_dimensions.balance_dimension_id%TYPE;
4428: l_new_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;
4429: l_index NUMBER;

Line 4676: l_legislation_code per_business_groups.legislation_code%TYPE;

4672: l_balance_amount NUMBER :=0;
4673: l_bal_total_amt NUMBER :=0;
4674: l_dimension_name VARCHAR2(100);
4675: i per_all_assignments_f.business_group_id%TYPE;
4676: l_legislation_code per_business_groups.legislation_code%TYPE;
4677: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
4678: l_index NUMBER;
4679: BEGIN
4680: i := p_business_group_id;