APPS.PQP_US_PENSION_EXTRACTS dependencies on PAY_BALANCE_TYPES

Line 48: ,primary_balance_id pay_balance_types.balance_type_id%TYPE

44: ,Pay_Value_Id pay_input_values_f.input_value_id%TYPE
45: ,input_value_id pay_input_values_f.input_value_id%TYPE
46: ,information_category pay_element_types_f.element_information_category%TYPE
47: ,pretax_category pay_element_types_f.element_information1%TYPE
48: ,primary_balance_id pay_balance_types.balance_type_id%TYPE
49: ,primary_balance_name pay_balance_types.balance_name%TYPE
50: ,CatchUp_ele_type_id pay_element_types_f.element_type_id%TYPE
51: ,CatchUp_ipv_id pay_input_values_f.input_value_id%TYPE
52: ,CatchUp_Balance_id pay_balance_types.balance_type_id%TYPE

Line 49: ,primary_balance_name pay_balance_types.balance_name%TYPE

45: ,input_value_id pay_input_values_f.input_value_id%TYPE
46: ,information_category pay_element_types_f.element_information_category%TYPE
47: ,pretax_category pay_element_types_f.element_information1%TYPE
48: ,primary_balance_id pay_balance_types.balance_type_id%TYPE
49: ,primary_balance_name pay_balance_types.balance_name%TYPE
50: ,CatchUp_ele_type_id pay_element_types_f.element_type_id%TYPE
51: ,CatchUp_ipv_id pay_input_values_f.input_value_id%TYPE
52: ,CatchUp_Balance_id pay_balance_types.balance_type_id%TYPE
53: ,Roth_Element Varchar2(90)

Line 52: ,CatchUp_Balance_id pay_balance_types.balance_type_id%TYPE

48: ,primary_balance_id pay_balance_types.balance_type_id%TYPE
49: ,primary_balance_name pay_balance_types.balance_name%TYPE
50: ,CatchUp_ele_type_id pay_element_types_f.element_type_id%TYPE
51: ,CatchUp_ipv_id pay_input_values_f.input_value_id%TYPE
52: ,CatchUp_Balance_id pay_balance_types.balance_type_id%TYPE
53: ,Roth_Element Varchar2(90)
54: ,Roth_ele_type_id pay_element_types_f.element_type_id%TYPE
55: ,Roth_ipv_id pay_input_values_f.input_value_id%TYPE
56: ,Roth_balance_id pay_balance_types.balance_type_id%TYPE

Line 56: ,Roth_balance_id pay_balance_types.balance_type_id%TYPE

52: ,CatchUp_Balance_id pay_balance_types.balance_type_id%TYPE
53: ,Roth_Element Varchar2(90)
54: ,Roth_ele_type_id pay_element_types_f.element_type_id%TYPE
55: ,Roth_ipv_id pay_input_values_f.input_value_id%TYPE
56: ,Roth_balance_id pay_balance_types.balance_type_id%TYPE
57: ,AT_ele_type_id pay_element_types_f.element_type_id%TYPE
58: ,AT_ipv_id pay_input_values_f.input_value_id%TYPE
59: ,AT_balance_id pay_balance_types.balance_type_id%TYPE
60: ,ATER_Element Varchar2(90)

Line 59: ,AT_balance_id pay_balance_types.balance_type_id%TYPE

55: ,Roth_ipv_id pay_input_values_f.input_value_id%TYPE
56: ,Roth_balance_id pay_balance_types.balance_type_id%TYPE
57: ,AT_ele_type_id pay_element_types_f.element_type_id%TYPE
58: ,AT_ipv_id pay_input_values_f.input_value_id%TYPE
59: ,AT_balance_id pay_balance_types.balance_type_id%TYPE
60: ,ATER_Element Varchar2(90)
61: ,ATER_Element_id pay_element_types_f.element_type_id%TYPE
62: ,ATER_Balance_id pay_balance_types.balance_type_id%TYPE
63: ,ER_Element Varchar2(90)

Line 62: ,ATER_Balance_id pay_balance_types.balance_type_id%TYPE

58: ,AT_ipv_id pay_input_values_f.input_value_id%TYPE
59: ,AT_balance_id pay_balance_types.balance_type_id%TYPE
60: ,ATER_Element Varchar2(90)
61: ,ATER_Element_id pay_element_types_f.element_type_id%TYPE
62: ,ATER_Balance_id pay_balance_types.balance_type_id%TYPE
63: ,ER_Element Varchar2(90)
64: ,ER_Element_id pay_element_types_f.element_type_id%TYPE
65: ,ER_Balance_id pay_balance_types.balance_type_id%TYPE
66: ,Roth_ER_Element Varchar2(90)

Line 65: ,ER_Balance_id pay_balance_types.balance_type_id%TYPE

61: ,ATER_Element_id pay_element_types_f.element_type_id%TYPE
62: ,ATER_Balance_id pay_balance_types.balance_type_id%TYPE
63: ,ER_Element Varchar2(90)
64: ,ER_Element_id pay_element_types_f.element_type_id%TYPE
65: ,ER_Balance_id pay_balance_types.balance_type_id%TYPE
66: ,Roth_ER_Element Varchar2(90)
67: ,RothER_Element_id pay_element_types_f.element_type_id%TYPE
68: ,RothER_Balance_id pay_balance_types.balance_type_id%TYPE
69: );

Line 68: ,RothER_Balance_id pay_balance_types.balance_type_id%TYPE

64: ,ER_Element_id pay_element_types_f.element_type_id%TYPE
65: ,ER_Balance_id pay_balance_types.balance_type_id%TYPE
66: ,Roth_ER_Element Varchar2(90)
67: ,RothER_Element_id pay_element_types_f.element_type_id%TYPE
68: ,RothER_Balance_id pay_balance_types.balance_type_id%TYPE
69: );
70: TYPE t_ele_details IS TABLE OF ele_details INDEX BY Binary_Integer;
71: g_element t_ele_details;
72:

Line 105: ( balance_name pay_balance_types.balance_name%TYPE

101: g_PreTax ele_count_details;
102:
103:
104: TYPE balance_details IS RECORD
105: ( balance_name pay_balance_types.balance_name%TYPE
106: ,balance_type_id pay_balance_types.balance_type_id%TYPE
107: ,defined_balance_id pay_defined_balances.defined_balance_id%TYPE
108: ,balance_dimension_id pay_balance_dimensions.balance_dimension_id%TYPE
109: ,dimension_name pay_balance_dimensions.dimension_name%TYPE

Line 106: ,balance_type_id pay_balance_types.balance_type_id%TYPE

102:
103:
104: TYPE balance_details IS RECORD
105: ( balance_name pay_balance_types.balance_name%TYPE
106: ,balance_type_id pay_balance_types.balance_type_id%TYPE
107: ,defined_balance_id pay_defined_balances.defined_balance_id%TYPE
108: ,balance_dimension_id pay_balance_dimensions.balance_dimension_id%TYPE
109: ,dimension_name pay_balance_dimensions.dimension_name%TYPE
110: );