DBA Data[Home] [Help]

APPS.PAY_COSTING_DETAIL_REP_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 876: select ''x'' from pay_element_types_f pet1

872: where petr.element_set_id = :cp_element_set_id
873: and petr.element_type_id = pcd.element_type_id
874: and petr.include_or_exclude = ''I''
875: union all
876: select ''x'' from pay_element_types_f pet1
877: where pet1.classification_id in
878: (select classification_id
879: from pay_ele_classification_rules
880: where element_set_id = :cp_element_set_id)

Line 1317: p_element_type_id pay_element_types_f.element_type_id%TYPE

1313:
1314: function get_costing_tax_unit_id(p_ACTION_TYPE pay_payroll_actions.action_type%TYPE,
1315: p_TAX_UNIT_ID pay_assignment_actions.TAX_UNIT_ID%TYPE,
1316: p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE,
1317: p_element_type_id pay_element_types_f.element_type_id%TYPE
1318: ) return number IS
1319: CURSOR c_tax_unit is
1320: select paa.tax_unit_id
1321: from pay_run_results prr,