DBA Data[Home] [Help]

APPS.PQP_US_PENSION_EXTRACTS dependencies on PAY_INPUT_VALUES_F

Line 43: (input_name pay_input_values_f.NAME%TYPE

39: TYPE t_extract_params IS TABLE OF extract_params INDEX BY Binary_Integer;
40: g_extract_params t_extract_params;
41:
42: TYPE ele_details IS RECORD
43: (input_name pay_input_values_f.NAME%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

Line 44: ,Pay_Value_Id pay_input_values_f.input_value_id%TYPE

40: g_extract_params t_extract_params;
41:
42: TYPE ele_details IS RECORD
43: (input_name pay_input_values_f.NAME%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

Line 45: ,input_value_id pay_input_values_f.input_value_id%TYPE

41:
42: TYPE ele_details IS RECORD
43: (input_name pay_input_values_f.NAME%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

Line 51: ,CatchUp_ipv_id pay_input_values_f.input_value_id%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)
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

Line 55: ,Roth_ipv_id pay_input_values_f.input_value_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
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

Line 58: ,AT_ipv_id pay_input_values_f.input_value_id%TYPE

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)
61: ,ATER_Element_id pay_element_types_f.element_type_id%TYPE
62: ,ATER_Balance_id pay_balance_types.balance_type_id%TYPE

Line 94: ,input_value_id pay_input_values_f.input_value_id%TYPE

90: g_primary_assig t_assig_details;
91:
92: TYPE ele_count_details IS RECORD
93: (ele_Count Number
94: ,input_value_id pay_input_values_f.input_value_id%TYPE
95: ,assignment_action_id pay_assignment_actions.assignment_action_id%TYPE
96: ,ele_type_id pay_element_types_f.element_type_id%TYPE
97: );
98: g_AfterTax ele_count_details;

Line 124: ,input_name pay_input_values_f.NAME%TYPE

120:
121:
122: TYPE eleinv_details IS RECORD
123: ( element_name pay_element_types_f.element_name%TYPE
124: ,input_name pay_input_values_f.NAME%TYPE
125: ,element_type_id pay_element_types_f.element_type_id%TYPE
126: ,input_value_id pay_input_values_f.input_value_id%TYPE
127: );
128: TYPE t_eleinv_details IS TABLE OF eleinv_details INDEX BY Binary_Integer;

Line 126: ,input_value_id pay_input_values_f.input_value_id%TYPE

122: TYPE eleinv_details IS RECORD
123: ( element_name pay_element_types_f.element_name%TYPE
124: ,input_name pay_input_values_f.NAME%TYPE
125: ,element_type_id pay_element_types_f.element_type_id%TYPE
126: ,input_value_id pay_input_values_f.input_value_id%TYPE
127: );
128: TYPE t_eleinv_details IS TABLE OF eleinv_details INDEX BY Binary_Integer;
129: g_element_input_dets t_eleinv_details;
130: