APPS.PQH_DE_CHILD_SEQ_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 40: lBusiness_group_id HR_ALL_ORGANIZATION_UNITS.BUSINESS_GROUP_ID%type;

36: -------------------------------------------------------------------------------------------------*/
37:
38: PROCEDURE REGENERATE_SEQ_NUM(errbuf OUT NOCOPY VARCHAR2, retcode OUT NOCOPY NUMBER, pBusiness_grp_id IN NUMBER, pEffective_date IN VARCHAR2) is
39:
40: lBusiness_group_id HR_ALL_ORGANIZATION_UNITS.BUSINESS_GROUP_ID%type;
41: cSeq number(2);
42: c_Age number;
43: --l_api_ovn number;
44: update_flag boolean;

Line 51: from HR_ALL_ORGANIZATION_UNITS

47: --Given Business Group name find business group id
48:
49: CURSOR C_B_Grp(pBusiness_grp_name varchar) is
50: select BUSINESS_GROUP_ID
51: from HR_ALL_ORGANIZATION_UNITS
52: where name=pBusiness_grp_name;
53:
54:
55: