APPS.BEN_PDW_COPY_BEN_TO_STG dependencies on HR_ORGANIZATION_INFORMATION

Line 2319: from hr_organization_information org

2315: --
2316:
2317: Cursor key_id_flex_num(c_bg_id NUMBER) IS
2318: select org_information5
2319: from hr_organization_information org
2320: where org.organization_id =c_bg_id
2321: and org.org_information_context = 'Business Group Information';
2322: --
2323: l_ovn_number NUMBER;

Line 2329: l_id_flex_num hr_organization_information.ORG_INFORMATION5%TYPE;

2325: l_business_group_id NUMBER;
2326: l_ppl_flx VARCHAR2(240);
2327: l_table_alias VARCHAR2(30);
2328: l_information1 NUMBER;
2329: l_id_flex_num hr_organization_information.ORG_INFORMATION5%TYPE;
2330:
2331: BEGIN
2332: hr_utility.set_location('Entering: '||l_proc,10);
2333: get_txn_details (