APPS.PQP_PENSION_EXTRACTS dependencies on PAY_BALANCE_TYPES

Line 53: ,primary_balance_id pay_balance_types.balance_type_id%TYPE

49: (input_name pay_input_values_f.NAME%TYPE
50: ,input_value_id pay_input_values_f.input_value_id%TYPE
51: ,information_category pay_element_types_f.element_information_category%TYPE
52: ,pretax_category pay_element_types_f.element_information1%TYPE
53: ,primary_balance_id pay_balance_types.balance_type_id%TYPE
54: ,primary_balance_name pay_balance_types.balance_name%TYPE
55: ,AT_ele_type_id pay_element_types_f.element_type_id%TYPE
56: ,AT_ipv_id pay_input_values_f.input_value_id%TYPE
57: ,AT_balance_id pay_balance_types.balance_type_id%TYPE

Line 54: ,primary_balance_name pay_balance_types.balance_name%TYPE

50: ,input_value_id pay_input_values_f.input_value_id%TYPE
51: ,information_category pay_element_types_f.element_information_category%TYPE
52: ,pretax_category pay_element_types_f.element_information1%TYPE
53: ,primary_balance_id pay_balance_types.balance_type_id%TYPE
54: ,primary_balance_name pay_balance_types.balance_name%TYPE
55: ,AT_ele_type_id pay_element_types_f.element_type_id%TYPE
56: ,AT_ipv_id pay_input_values_f.input_value_id%TYPE
57: ,AT_balance_id pay_balance_types.balance_type_id%TYPE
58: ,CatchUp_ele_type_id pay_element_types_f.element_type_id%TYPE

Line 57: ,AT_balance_id pay_balance_types.balance_type_id%TYPE

53: ,primary_balance_id pay_balance_types.balance_type_id%TYPE
54: ,primary_balance_name pay_balance_types.balance_name%TYPE
55: ,AT_ele_type_id pay_element_types_f.element_type_id%TYPE
56: ,AT_ipv_id pay_input_values_f.input_value_id%TYPE
57: ,AT_balance_id pay_balance_types.balance_type_id%TYPE
58: ,CatchUp_ele_type_id pay_element_types_f.element_type_id%TYPE
59: ,CatchUp_ipv_id pay_input_values_f.input_value_id%TYPE
60: ,CatchUp_Balance_id pay_balance_types.balance_type_id%TYPE
61: ,ER_Balance_id pay_balance_types.balance_type_id%TYPE

Line 60: ,CatchUp_Balance_id pay_balance_types.balance_type_id%TYPE

56: ,AT_ipv_id pay_input_values_f.input_value_id%TYPE
57: ,AT_balance_id pay_balance_types.balance_type_id%TYPE
58: ,CatchUp_ele_type_id pay_element_types_f.element_type_id%TYPE
59: ,CatchUp_ipv_id pay_input_values_f.input_value_id%TYPE
60: ,CatchUp_Balance_id pay_balance_types.balance_type_id%TYPE
61: ,ER_Balance_id pay_balance_types.balance_type_id%TYPE
62: ,ATER_Balance_id pay_balance_types.balance_type_id%TYPE
63: );
64:

Line 61: ,ER_Balance_id pay_balance_types.balance_type_id%TYPE

57: ,AT_balance_id pay_balance_types.balance_type_id%TYPE
58: ,CatchUp_ele_type_id pay_element_types_f.element_type_id%TYPE
59: ,CatchUp_ipv_id pay_input_values_f.input_value_id%TYPE
60: ,CatchUp_Balance_id pay_balance_types.balance_type_id%TYPE
61: ,ER_Balance_id pay_balance_types.balance_type_id%TYPE
62: ,ATER_Balance_id pay_balance_types.balance_type_id%TYPE
63: );
64:
65: TYPE t_ele_details IS TABLE OF ele_details INDEX BY BINARY_INTEGER;

Line 62: ,ATER_Balance_id pay_balance_types.balance_type_id%TYPE

58: ,CatchUp_ele_type_id pay_element_types_f.element_type_id%TYPE
59: ,CatchUp_ipv_id pay_input_values_f.input_value_id%TYPE
60: ,CatchUp_Balance_id pay_balance_types.balance_type_id%TYPE
61: ,ER_Balance_id pay_balance_types.balance_type_id%TYPE
62: ,ATER_Balance_id pay_balance_types.balance_type_id%TYPE
63: );
64:
65: TYPE t_ele_details IS TABLE OF ele_details INDEX BY BINARY_INTEGER;
66: g_element t_ele_details;

Line 111: (balance_name pay_balance_types.balance_name%TYPE

107: g_PreTax ele_count_details;
108:
109:
110: TYPE balance_details IS RECORD
111: (balance_name pay_balance_types.balance_name%TYPE
112: ,balance_type_id pay_balance_types.balance_type_id%TYPE
113: ,defined_balance_id pay_defined_balances.defined_balance_id%TYPE
114: );
115:

Line 112: ,balance_type_id pay_balance_types.balance_type_id%TYPE

108:
109:
110: TYPE balance_details IS RECORD
111: (balance_name pay_balance_types.balance_name%TYPE
112: ,balance_type_id pay_balance_types.balance_type_id%TYPE
113: ,defined_balance_id pay_defined_balances.defined_balance_id%TYPE
114: );
115:
116: TYPE t_balance_details IS TABLE OF balance_details INDEX BY BINARY_INTEGER;