APPS.PAY_NL_PAYFILE dependencies on HR_ALL_ORGANIZATION_UNITS

Line 43: hr_All_organization_units hou,

39: AND ppm.payee_id is NOT NULL;
40: --
41: cursor csr_org_count (p_org_id pay_personal_payment_methods_f.payee_id%TYPE) is
42: select count(*) from
43: hr_All_organization_units hou,
44: hr_organization_information hoi
45: where hou.organization_id = p_org_id
46: and hoi.organization_id = hou.organization_id
47: and hoi.org_information_context = 'CLASS'

Line 484: ,hr_all_organization_units hou

480: --
481: CURSOR csr_get_org_address(p_payee_id NUMBER) IS
482: SELECT substr(hr_general.decode_lookup('HR_NL_CITY',town_or_city),1,35) town_or_city
483: FROM hr_locations_all hla
484: ,hr_all_organization_units hou
485: WHERE hou.organization_id = p_payee_id
486: AND hou.location_id = hla.location_id;
487: --
488: l_payee_address VARCHAR2(35);