APPS.PAY_DK_SOE dependencies on HR_ORGANIZATION_UNITS

Line 369: , hr_organization_units hou

365: select hou.name
366: from
367: pay_run_result_values rrv
368: , pay_input_values_f iv
369: , hr_organization_units hou
370: where rrv.run_result_id = p_run_result_id
371: and rrv.input_value_id = iv.input_value_id
372: and iv.name = 'Third Party Payee'
373: and p_effective_date between

Line 647: FROM hr_organization_units

643: /* Added for display of Pension Provider balances */
644:
645: CURSOR csr_get_org_name( p_org_id number) IS
646: SELECT name
647: FROM hr_organization_units
648: WHERE organization_id = p_org_id ;
649:
650: l_org_name VARCHAR(80);
651: