DBA Data[Home] [Help]

APPS.PQP_US_PENSION_EXTRACTS dependencies on PAY_ELEMENT_TYPES_F

Line 28: ,element_type_id pay_element_types_f.element_type_id%TYPE

24: ,currency_code per_business_groups.currency_code%TYPE
25: ,concurrent_req_id ben_ext_rslt.request_id%TYPE
26: ,ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE
27: ,element_set_id pay_element_sets.element_set_id%TYPE
28: ,element_type_id pay_element_types_f.element_type_id%TYPE
29: ,payroll_id pay_payrolls_f.payroll_id%TYPE
30: ,gre_org_id hr_all_organization_units.organization_id%TYPE
31: ,con_set_id pay_consolidation_sets.consolidation_set_id%TYPE
32: ,selection_criteria Varchar2(90)

Line 46: ,information_category pay_element_types_f.element_information_category%TYPE

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
50: ,CatchUp_ele_type_id pay_element_types_f.element_type_id%TYPE

Line 47: ,pretax_category pay_element_types_f.element_information1%TYPE

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
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

Line 50: ,CatchUp_ele_type_id pay_element_types_f.element_type_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)
54: ,Roth_ele_type_id pay_element_types_f.element_type_id%TYPE

Line 54: ,Roth_ele_type_id pay_element_types_f.element_type_id%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
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

Line 57: ,AT_ele_type_id pay_element_types_f.element_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)
61: ,ATER_Element_id pay_element_types_f.element_type_id%TYPE

Line 61: ,ATER_Element_id pay_element_types_f.element_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)
64: ,ER_Element_id pay_element_types_f.element_type_id%TYPE
65: ,ER_Balance_id pay_balance_types.balance_type_id%TYPE

Line 64: ,ER_Element_id pay_element_types_f.element_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)
67: ,RothER_Element_id pay_element_types_f.element_type_id%TYPE
68: ,RothER_Balance_id pay_balance_types.balance_type_id%TYPE

Line 67: ,RothER_Element_id pay_element_types_f.element_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: );
70: TYPE t_ele_details IS TABLE OF ele_details INDEX BY Binary_Integer;
71: g_element t_ele_details;

Line 96: ,ele_type_id pay_element_types_f.element_type_id%TYPE

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;
99: g_Roth ele_count_details;
100: g_CatchUp ele_count_details;

Line 123: ( element_name pay_element_types_f.element_name%TYPE

119: g_balance_dim t_balance_dim;
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: );

Line 125: ,element_type_id pay_element_types_f.element_type_id%TYPE

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;
129: g_element_input_dets t_eleinv_details;

Line 138: ,elementname pay_element_types_f.element_name%TYPE

134: ( extract_name ben_ext_dfn.NAME%TYPE
135: ,reporting_options hr_lookups.meaning%TYPE
136: ,selection_criteria hr_lookups.meaning%TYPE
137: ,elementset PAY_ELEMENT_SETS.ELEMENT_SET_NAME%TYPE
138: ,elementname pay_element_types_f.element_name%TYPE
139: ,beginningdt Date
140: ,endingdt Date
141: ,grename hr_organization_units.NAME%TYPE
142: ,payrollname PAY_PAYROLLS_F.PAYROLL_NAME%TYPE