APPS.PQP_PENSION_EXTRACTS dependencies on PER_BUSINESS_GROUPS

Line 453: FROM per_business_groups_perf

449: (p_business_group_id IN NUMBER) RETURN VARCHAR2 IS
450:
451: CURSOR csr_bg_code (c_business_group_id IN NUMBER)IS
452: SELECT legislation_code
453: FROM per_business_groups_perf
454: WHERE business_group_id = c_business_group_id;
455: l_proc_name CONSTANT VARCHAR2(150) := g_proc_name ||'Get_Leg_Code';
456:
457: BEGIN

Line 804: l_legislation_code per_business_groups.legislation_code%TYPE;

800: l_element_name pay_element_types_f.element_name%TYPE;
801: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
802: l_balance_name pay_balance_types.balance_name%TYPE;
803: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
804: l_legislation_code per_business_groups.legislation_code%TYPE;
805: l_proc_name VARCHAR2(150) := g_proc_name ||'Get_Element_Info';
806: l_ele_info_rec csr_ele_info%ROWTYPE;
807:
808: BEGIN

Line 3387: l_legislation_code per_business_groups.legislation_code%TYPE;

3383: l_effective_date DATE;
3384: l_return_value VARCHAR2(50) := '0';
3385: l_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
3386: l_error_message VARCHAR2(3000);
3387: l_legislation_code per_business_groups.legislation_code%TYPE;
3388: l_index NUMBER :=0;
3389: l_proc_name VARCHAR2(150) := g_proc_name ||'Get_Element_Entry_Value';
3390: BEGIN
3391: hr_utility.set_location('Entering: '||l_proc_name, 5);

Line 3478: l_legislation_code per_business_groups.legislation_code%TYPE;

3474: l_balance_amount NUMBER :=0;
3475: l_bal_total_amt NUMBER :=0;
3476: l_dimension_name VARCHAR2(100);
3477: i per_all_assignments_f.business_group_id%TYPE;
3478: l_legislation_code per_business_groups.legislation_code%TYPE;
3479: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
3480: l_index NUMBER;
3481: l_valid_person_chk VARCHAR2(2);
3482: l_organization_id NUMBER(15);

Line 3905: l_legislation_code per_business_groups.legislation_code%TYPE;

3901: l_bal_total_amt NUMBER := 0;
3902: l_balance_amount NUMBER := 0;
3903: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
3904: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;
3905: l_legislation_code per_business_groups.legislation_code%TYPE;
3906: i per_all_assignments_f.business_group_id%TYPE;
3907: l_input_value_id pay_input_values_f.input_value_id%TYPE;
3908: l_valid_action VARCHAR2(2);
3909: l_proc_name VARCHAR2(150) := g_proc_name ||'Get_Pay_value';

Line 4050: FROM per_business_groups_perf pbg

4046: -- Get the Legislation Code and Curreny Code
4047: CURSOR csr_leg_code (c_business_group_id IN NUMBER) IS
4048: SELECT pbg.legislation_code
4049: ,pbg.currency_code
4050: FROM per_business_groups_perf pbg
4051: WHERE pbg.business_group_id = c_business_group_id;
4052:
4053: -- Check the eligibility to the person enrolled for pension for passed values.
4054: CURSOR csr_chk_asg