APPS.PAY_MX_FF_UDFS dependencies on HR_ORGANIZATION_UNITS

Line 941: p_tax_unit_id hr_organization_units.organization_id%TYPE,

937:
938: --
939:
940: FUNCTION get_idw (p_assignment_id per_all_assignments_f.assignment_id%TYPE,
941: p_tax_unit_id hr_organization_units.organization_id%TYPE,
942: p_effective_date DATE,
943: p_mode VARCHAR2,
944: p_fixed_idw OUT NOCOPY NUMBER,
945: p_variable_idw OUT NOCOPY NUMBER)

Line 980: CURSOR c_get_idw_calc_method (cp_org_id hr_organization_units.organization_id%TYPE,

976: AND pa.effective_date BETWEEN cp_idw_start_date AND cp_idw_report_date
977: ORDER BY aa.action_sequence desc;
978:
979: -- cursor to get the IDW Calc method
980: CURSOR c_get_idw_calc_method (cp_org_id hr_organization_units.organization_id%TYPE,
981: cp_eff_date DATE )
982: IS
983: select hoi.org_information10
984: from hr_organization_units hou,

Line 984: from hr_organization_units hou,

980: CURSOR c_get_idw_calc_method (cp_org_id hr_organization_units.organization_id%TYPE,
981: cp_eff_date DATE )
982: IS
983: select hoi.org_information10
984: from hr_organization_units hou,
985: hr_organization_information hoi
986: where hou.organization_id = cp_org_id
987: and hoi.org_information_context ='MX_SOC_SEC_DETAILS'
988: and hou.organization_id = hoi.organization_id