APPS.PAY_JP_UITE_ARCH_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 2161: CURSOR lcu_ei_org_info(p_organization_id hr_organization_information.organization_id%TYPE)

2157: -- CALLED BY
2158: -- initialize procedure
2159: --
2160: --**********************************************************************
2161: CURSOR lcu_ei_org_info(p_organization_id hr_organization_information.organization_id%TYPE)
2162: IS
2163: SELECT NVL(org_information15,gc_date_earned)
2164: ,NVL(org_information16,12)
2165: FROM hr_organization_information HOI

Line 2165: FROM hr_organization_information HOI

2161: CURSOR lcu_ei_org_info(p_organization_id hr_organization_information.organization_id%TYPE)
2162: IS
2163: SELECT NVL(org_information15,gc_date_earned)
2164: ,NVL(org_information16,12)
2165: FROM hr_organization_information HOI
2166: WHERE HOI.org_information_context= 'JP_LI_UNION_INFO'
2167: AND organization_id= p_organization_id;
2168: -- Local Variables
2169: lc_procedure VARCHAR2(200);

Line 2842: FROM hr_organization_information HOI

2838: ,HOI.org_information8 LOCATION_NAME
2839: ,HOI.org_information9 EMPLOYER_NAME
2840: ,HOI.org_information10 EMPLOYER_FULL_NAME
2841: ,HOI.org_information11 COMPANY_PHONE
2842: FROM hr_organization_information HOI
2843: WHERE HOI.org_information_context = 'JP_LI_UNION_INFO'
2844: AND HOI.organization_id = gr_parameters.labor_insorg_id;
2845: --
2846: lc_proc CONSTANT VARCHAR2(61) := gc_package || 'deinitialise_code';