DBA Data[Home] [Help]

APPS.PAY_COSTING_DETAIL_REP_PKG dependencies on PAY_ELEMENT_TYPES_F

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

906: where petr.element_set_id = :cp_element_set_id
907: and petr.element_type_id = pcd.element_type_id
908: and petr.include_or_exclude = ''I''
909: union all
910: select ''x'' from pay_element_types_f pet1
911: where pet1.classification_id in
912: (select classification_id
913: from pay_ele_classification_rules
914: where element_set_id = :cp_element_set_id)

Line 1382: p_element_type_id pay_element_types_f.element_type_id%TYPE

1378:
1379: function get_costing_tax_unit_id(p_ACTION_TYPE pay_payroll_actions.action_type%TYPE,
1380: p_TAX_UNIT_ID pay_assignment_actions.TAX_UNIT_ID%TYPE,
1381: p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE,
1382: p_element_type_id pay_element_types_f.element_type_id%TYPE
1383: ) return number IS
1384: CURSOR c_tax_unit is
1385: select paa.tax_unit_id
1386: from pay_run_results prr,