eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_FI_ARCHIVE_ACRA dependencies on PAY_ELEMENT_TYPES_F

Line 126: l_element_name pay_element_types_f.element_name%TYPE;

122: l_emp_id hr_organization_units.organization_id%TYPE ;
123: l_emp_name hr_organization_units.name%TYPE;
124: l_le_name hr_organization_units.name%TYPE ;
125: l_lu_name hr_organization_units.name%TYPE ;
126: l_element_name pay_element_types_f.element_name%TYPE;
127: l_element_set_name pay_element_sets.element_set_name%TYPE;
128: l_business_id hr_organization_information.org_information1%TYPE ;
129: l_y_number hr_organization_information.org_information1%TYPE ;
130: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

Line 131: l_element_type_id pay_element_types_f.element_type_id%TYPE ;

127: l_element_set_name pay_element_sets.element_set_name%TYPE;
128: l_business_id hr_organization_information.org_information1%TYPE ;
129: l_y_number hr_organization_information.org_information1%TYPE ;
130: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
131: l_element_type_id pay_element_types_f.element_type_id%TYPE ;
132: d_element_type_id pay_element_types_f.element_type_id%TYPE ;
133: l_element_set_id pay_element_set_members.element_set_id%TYPE;
134: l_con_Segments pay_cost_allocation_keyflex.concatenated_segments%TYPE;
135: l_cost_allocation_softflex_id pay_costs.cost_allocation_keyflex_id%TYPE;

Line 132: d_element_type_id pay_element_types_f.element_type_id%TYPE ;

128: l_business_id hr_organization_information.org_information1%TYPE ;
129: l_y_number hr_organization_information.org_information1%TYPE ;
130: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
131: l_element_type_id pay_element_types_f.element_type_id%TYPE ;
132: d_element_type_id pay_element_types_f.element_type_id%TYPE ;
133: l_element_set_id pay_element_set_members.element_set_id%TYPE;
134: l_con_Segments pay_cost_allocation_keyflex.concatenated_segments%TYPE;
135: l_cost_allocation_softflex_id pay_costs.cost_allocation_keyflex_id%TYPE;
136: l_debit_or_credit pay_costs.debit_or_credit%TYPE;

Line 174: pay_element_types_f.element_type_id%TYPE)

170: AND o1.organization_id =hoi2.organization_id
171: AND hoi2.ORG_INFORMATION_CONTEXT='FI_LEGAL_EMPLOYER_DETAILS' ;
172: rg_Legal_Emp_Details csr_Legal_Emp_Details%rowtype;
173: Cursor csr_Element_Details(csr_v_element_type_id
174: pay_element_types_f.element_type_id%TYPE)
175: IS
176: SELECT element_name
177: FROM pay_element_types_f
178: WHERE element_type_id=csr_v_element_type_id

Line 177: FROM pay_element_types_f

173: Cursor csr_Element_Details(csr_v_element_type_id
174: pay_element_types_f.element_type_id%TYPE)
175: IS
176: SELECT element_name
177: FROM pay_element_types_f
178: WHERE element_type_id=csr_v_element_type_id
179: AND (business_group_id=l_business_group_id
180: OR legislation_code='FI');
181: rg_Element_Details csr_Element_Details%rowtype;

Line 213: pay_element_types_f.element_type_id%TYPE)

209: AND hoi1.org_information_context = 'CLASS'
210: AND o1.organization_id =hoi2.organization_id
211: AND hoi2.ORG_INFORMATION_CONTEXT='FI_LOCAL_UNITS';
212: Cursor csr_Costing_Details(csr_V_element_type_id
213: pay_element_types_f.element_type_id%TYPE)
214: IS
215: SELECT Distinct pet.element_type_id
216: ,pet.element_name
217: ,pcak.concatenated_segments

Line 221: FROM pay_element_types_f pet

217: ,pcak.concatenated_segments
218: ,pc.cost_allocation_keyflex_id
219: ,pc.debit_or_credit
220: ,sum(pc.costed_value) costed_value
221: FROM pay_element_types_f pet
222: , pay_input_values_f piv
223: , pay_run_results prr
224: /*, pay_element_set_members pesm*/
225: , pay_costs pc