APPS.PQP_GB_CPX_EXTRACT_FUNCTIONS dependencies on PAY_BALANCE_TYPES

Line 26: g_pension_bal_name pay_balance_types.balance_name%TYPE;

22: g_effective_start_date DATE;
23: g_effective_end_date DATE;
24: g_header_system_element ben_ext_rslt_dtl.val_01%TYPE;
25: g_initial_ext_date DATE;
26: g_pension_bal_name pay_balance_types.balance_name%TYPE;
27: g_pension_ele_name pay_element_types_f.element_name%TYPE;
28: g_emp_cont_iv_name pay_input_values_f.NAME%TYPE;
29: g_superann_refno_iv_name pay_input_values_f.NAME%TYPE;
30: g_superann_sal_bal_name pay_balance_types.balance_name%TYPE;

Line 30: g_superann_sal_bal_name pay_balance_types.balance_name%TYPE;

26: g_pension_bal_name pay_balance_types.balance_name%TYPE;
27: g_pension_ele_name pay_element_types_f.element_name%TYPE;
28: g_emp_cont_iv_name pay_input_values_f.NAME%TYPE;
29: g_superann_refno_iv_name pay_input_values_f.NAME%TYPE;
30: g_superann_sal_bal_name pay_balance_types.balance_name%TYPE;
31: g_additional_cont_bal_name pay_balance_types.balance_name%TYPE;
32: g_buyback_cont_bal_name pay_balance_types.balance_name%TYPE;
33:
34: -- Bug Fix 4721921

Line 31: g_additional_cont_bal_name pay_balance_types.balance_name%TYPE;

27: g_pension_ele_name pay_element_types_f.element_name%TYPE;
28: g_emp_cont_iv_name pay_input_values_f.NAME%TYPE;
29: g_superann_refno_iv_name pay_input_values_f.NAME%TYPE;
30: g_superann_sal_bal_name pay_balance_types.balance_name%TYPE;
31: g_additional_cont_bal_name pay_balance_types.balance_name%TYPE;
32: g_buyback_cont_bal_name pay_balance_types.balance_name%TYPE;
33:
34: -- Bug Fix 4721921
35: g_ni_ele_type_id NUMBER;

Line 32: g_buyback_cont_bal_name pay_balance_types.balance_name%TYPE;

28: g_emp_cont_iv_name pay_input_values_f.NAME%TYPE;
29: g_superann_refno_iv_name pay_input_values_f.NAME%TYPE;
30: g_superann_sal_bal_name pay_balance_types.balance_name%TYPE;
31: g_additional_cont_bal_name pay_balance_types.balance_name%TYPE;
32: g_buyback_cont_bal_name pay_balance_types.balance_name%TYPE;
33:
34: -- Bug Fix 4721921
35: g_ni_ele_type_id NUMBER;
36: g_ni_cat_iv_id NUMBER;

Line 94: FROM pay_balance_types

90:
91: CURSOR csr_get_pay_bal_id (c_balance_name VARCHAR2)
92: IS
93: SELECT balance_type_id
94: FROM pay_balance_types
95: WHERE balance_name = c_balance_name
96: AND ( (business_group_id IS NULL AND legislation_code IS NULL)
97: OR ( business_group_id IS NULL
98: AND legislation_code = g_legislation_code

Line 103: g_additional_cont_bal_id pay_balance_types.balance_type_id%TYPE;

99: )
100: OR (business_group_id = g_business_group_id)
101: );
102:
103: g_additional_cont_bal_id pay_balance_types.balance_type_id%TYPE;
104: g_pension_bal_id pay_balance_types.balance_type_id%TYPE;
105: g_superann_sal_bal_id pay_balance_types.balance_type_id%TYPE;
106: g_buyback_cont_bal_id pay_balance_types.balance_type_id%TYPE;
107:

Line 104: g_pension_bal_id pay_balance_types.balance_type_id%TYPE;

100: OR (business_group_id = g_business_group_id)
101: );
102:
103: g_additional_cont_bal_id pay_balance_types.balance_type_id%TYPE;
104: g_pension_bal_id pay_balance_types.balance_type_id%TYPE;
105: g_superann_sal_bal_id pay_balance_types.balance_type_id%TYPE;
106: g_buyback_cont_bal_id pay_balance_types.balance_type_id%TYPE;
107:
108: -- Cursor to get element type id from an element name

Line 105: g_superann_sal_bal_id pay_balance_types.balance_type_id%TYPE;

101: );
102:
103: g_additional_cont_bal_id pay_balance_types.balance_type_id%TYPE;
104: g_pension_bal_id pay_balance_types.balance_type_id%TYPE;
105: g_superann_sal_bal_id pay_balance_types.balance_type_id%TYPE;
106: g_buyback_cont_bal_id pay_balance_types.balance_type_id%TYPE;
107:
108: -- Cursor to get element type id from an element name
109:

Line 106: g_buyback_cont_bal_id pay_balance_types.balance_type_id%TYPE;

102:
103: g_additional_cont_bal_id pay_balance_types.balance_type_id%TYPE;
104: g_pension_bal_id pay_balance_types.balance_type_id%TYPE;
105: g_superann_sal_bal_id pay_balance_types.balance_type_id%TYPE;
106: g_buyback_cont_bal_id pay_balance_types.balance_type_id%TYPE;
107:
108: -- Cursor to get element type id from an element name
109:
110: CURSOR csr_get_pay_ele_id (c_element_name VARCHAR2, c_effective_date DATE)