APPS.PQP_NL_EXT_FUNCTIONS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 39: FROM hr_all_organization_units

35: l_enabled varchar2(1) := 'N';
36:
37: CURSOR c_get_bgid IS
38: SELECT business_group_id
39: FROM hr_all_organization_units
40: WHERE organization_id = p_organization_id;
41:
42: BEGIN
43:

Line 114: FROM hr_all_organization_units

110: AND chg_evt_cd = 'COAPPD';
111:
112: CURSOR c_get_bgid IS
113: SELECT business_group_id
114: FROM hr_all_organization_units
115: WHERE organization_id = p_organization_id;
116:
117: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;
118: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;

Line 510: FROM hr_all_organization_units

506: l_enabled varchar2(1) := 'N';
507:
508: CURSOR c_get_bgid IS
509: SELECT business_group_id
510: FROM hr_all_organization_units
511: WHERE organization_id = p_organization_id;
512:
513: BEGIN
514:

Line 561: FROM hr_all_organization_units

557: ) IS
558:
559: CURSOR c_get_bgid IS
560: SELECT business_group_id
561: FROM hr_all_organization_units
562: WHERE organization_id = p_organization_id;
563:
564: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;
565: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;