DBA Data[Home] [Help]

APPS.PQP_PENSION_EXTRACTS dependencies on PAY_ELEMENT_TYPES_F

Line 31: ,element_type_id pay_element_types_f.element_type_id%TYPE

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

Line 51: ,information_category pay_element_types_f.element_information_category%TYPE

47: -- Used to maintain the element details
48: TYPE ele_details IS RECORD
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

Line 52: ,pretax_category pay_element_types_f.element_information1%TYPE

48: TYPE ele_details IS RECORD
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

Line 55: ,AT_ele_type_id pay_element_types_f.element_type_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
59: ,CatchUp_ipv_id pay_input_values_f.input_value_id%TYPE

Line 58: ,CatchUp_ele_type_id pay_element_types_f.element_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
62: ,ATER_Balance_id pay_balance_types.balance_type_id%TYPE

Line 102: ,ele_type_id pay_element_types_f.element_type_id%TYPE

98: TYPE ele_count_details IS RECORD
99: (count number
100: ,input_value_id pay_input_values_f.input_value_id%TYPE
101: ,assignment_action_id pay_assignment_actions.assignment_action_id%TYPE
102: ,ele_type_id pay_element_types_f.element_type_id%TYPE
103: );
104:
105: g_AfterTax ele_count_details;
106: g_CatchUp ele_count_details;

Line 121: (element_name pay_element_types_f.element_name%TYPE

117: g_balance_detls t_balance_details;
118:
119:
120: TYPE eleinv_details IS RECORD
121: (element_name pay_element_types_f.element_name%TYPE
122: ,input_name pay_input_values_f.NAME%TYPE
123: ,element_type_id pay_element_types_f.element_type_id%TYPE
124: ,input_value_id pay_input_values_f.input_value_id%TYPE
125: );

Line 123: ,element_type_id pay_element_types_f.element_type_id%TYPE

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

Line 136: ,elementname pay_element_types_f.element_name%TYPE

132: (extract_name ben_ext_dfn.NAME%TYPE
133: ,reporting_options hr_lookups.meaning%TYPE
134: ,selection_criteria hr_lookups.meaning%TYPE
135: ,elementset pay_element_sets.element_set_name%TYPE
136: ,elementname pay_element_types_f.element_name%TYPE
137: ,beginningdt date
138: ,endingdt date
139: ,grename hr_organization_units.NAME%TYPE
140: ,payrollname pay_payrolls_f.payroll_name%TYPE