DBA Data[Home] [Help]

APPS.PAY_MX_TRR_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 372: hr_organization_information hoi

368: CURSOR get_legal_employer_details (p_legal_employer_id NUMBER) IS
369: SELECT hoi.org_information1 legal_employer_name,
370: hoi.org_information2 RFC_ID
371: FROM hr_organization_units hou,
372: hr_organization_information hoi
373: WHERE hoi.organization_id = hou.organization_id
374: AND hoi.org_information_context = 'MX_TAX_REGISTRATION'
375: AND hoi.organization_id = p_legal_employer_id ;
376:

Line 382: hr_organization_information hoi

378: CURSOR get_gre_details (p_gre_id NUMBER) IS
379: SELECT hou.name GRE_Name,
380: hoi.org_information1 ss_id
381: FROM hr_organization_units hou,
382: hr_organization_information hoi
383: WHERE hou.organization_id = hoi.organization_id
384: AND hoi.org_information_context = 'MX_SOC_SEC_DETAILS'
385: AND hoi.organization_id = p_gre_id;
386: