APPS.IGS_OR_VAL_OUR dependencies on IGS_OR_UNIT

Line 14: cp_org_unit_cd IGS_OR_UNIT.org_unit_cd%TYPE,

10: p_child_start_dt IN DATE ,
11: p_message_name OUT NOCOPY VARCHAR2 )
12: RETURN BOOLEAN AS
13: CURSOR c_ou (
14: cp_org_unit_cd IGS_OR_UNIT.org_unit_cd%TYPE,
15: cp_start_dt IGS_OR_UNIT.start_dt%TYPE) IS
16: SELECT org_unit_cd
17: FROM IGS_OR_UNIT
18: WHERE org_unit_cd = cp_org_unit_cd

Line 15: cp_start_dt IGS_OR_UNIT.start_dt%TYPE) IS

11: p_message_name OUT NOCOPY VARCHAR2 )
12: RETURN BOOLEAN AS
13: CURSOR c_ou (
14: cp_org_unit_cd IGS_OR_UNIT.org_unit_cd%TYPE,
15: cp_start_dt IGS_OR_UNIT.start_dt%TYPE) IS
16: SELECT org_unit_cd
17: FROM IGS_OR_UNIT
18: WHERE org_unit_cd = cp_org_unit_cd
19: AND start_dt = cp_start_dt;

Line 17: FROM IGS_OR_UNIT

13: CURSOR c_ou (
14: cp_org_unit_cd IGS_OR_UNIT.org_unit_cd%TYPE,
15: cp_start_dt IGS_OR_UNIT.start_dt%TYPE) IS
16: SELECT org_unit_cd
17: FROM IGS_OR_UNIT
18: WHERE org_unit_cd = cp_org_unit_cd
19: AND start_dt = cp_start_dt;
20: --
21: CURSOR c_ou_os (

Line 22: cp_org_unit_cd IGS_OR_UNIT.org_unit_cd%TYPE,

18: WHERE org_unit_cd = cp_org_unit_cd
19: AND start_dt = cp_start_dt;
20: --
21: CURSOR c_ou_os (
22: cp_org_unit_cd IGS_OR_UNIT.org_unit_cd%TYPE,
23: cp_start_dt IGS_OR_UNIT.start_dt%TYPE) IS
24: SELECT s_org_status
25: FROM IGS_OR_UNIT,
26: IGS_OR_STATUS

Line 23: cp_start_dt IGS_OR_UNIT.start_dt%TYPE) IS

19: AND start_dt = cp_start_dt;
20: --
21: CURSOR c_ou_os (
22: cp_org_unit_cd IGS_OR_UNIT.org_unit_cd%TYPE,
23: cp_start_dt IGS_OR_UNIT.start_dt%TYPE) IS
24: SELECT s_org_status
25: FROM IGS_OR_UNIT,
26: IGS_OR_STATUS
27: WHERE org_unit_cd = cp_org_unit_cd

Line 25: FROM IGS_OR_UNIT,

21: CURSOR c_ou_os (
22: cp_org_unit_cd IGS_OR_UNIT.org_unit_cd%TYPE,
23: cp_start_dt IGS_OR_UNIT.start_dt%TYPE) IS
24: SELECT s_org_status
25: FROM IGS_OR_UNIT,
26: IGS_OR_STATUS
27: WHERE org_unit_cd = cp_org_unit_cd
28: AND start_dt = cp_start_dt
29: AND IGS_OR_STATUS.org_status = IGS_OR_UNIT.org_status

Line 29: AND IGS_OR_STATUS.org_status = IGS_OR_UNIT.org_status

25: FROM IGS_OR_UNIT,
26: IGS_OR_STATUS
27: WHERE org_unit_cd = cp_org_unit_cd
28: AND start_dt = cp_start_dt
29: AND IGS_OR_STATUS.org_status = IGS_OR_UNIT.org_status
30: AND s_org_status = 'INACTIVE';
31: --
32: v_org_unit_exists BOOLEAN DEFAULT FALSE;
33: v_other_detail VARCHAR2(255);

Line 37: p_org_unit_cd IN IGS_OR_UNIT.org_unit_cd%TYPE,

33: v_other_detail VARCHAR2(255);
34: --
35: -- Local function to perform recursive loop.
36: FUNCTION orgp_val_our_loop (
37: p_org_unit_cd IN IGS_OR_UNIT.org_unit_cd%TYPE,
38: p_start_dt IN IGS_OR_UNIT.start_dt%TYPE)
39: RETURN BOOLEAN
40: IS
41: CURSOR c_our IS

Line 38: p_start_dt IN IGS_OR_UNIT.start_dt%TYPE)

34: --
35: -- Local function to perform recursive loop.
36: FUNCTION orgp_val_our_loop (
37: p_org_unit_cd IN IGS_OR_UNIT.org_unit_cd%TYPE,
38: p_start_dt IN IGS_OR_UNIT.start_dt%TYPE)
39: RETURN BOOLEAN
40: IS
41: CURSOR c_our IS
42: SELECT parent_org_unit_cd,

Line 44: FROM IGS_OR_UNIT_REL

40: IS
41: CURSOR c_our IS
42: SELECT parent_org_unit_cd,
43: parent_start_dt
44: FROM IGS_OR_UNIT_REL
45: WHERE child_org_unit_cd = p_org_unit_cd
46: AND child_start_dt = p_start_dt
47: AND logical_delete_dt IS NULL;
48: --