APPS.IGS_PE_GEN_001 dependencies on IGS_PE_DATA_GROUPS

Line 45: FROM IGS_PE_PRIV_LEVEL lvl, IGS_PE_DATA_GROUPS DG

41: ln_data_Group_Id NUMBER(15);
42:
43: cursor c1 (lnpersonid number) is
44: SELECT max(dg.lvl) Max_Level, lvl.data_group_id, lvl_description
45: FROM IGS_PE_PRIV_LEVEL lvl, IGS_PE_DATA_GROUPS DG
46: WHERE lvl.person_id = lnpersonid
47: AND TRUNC(SYSDATE) BETWEEN lvl.start_date AND NVL(lvl.end_date,TRUNC(SYSDATE))
48: and lvl.DATA_GROUP_ID = DG.DATA_GROUP_ID
49: GROUP BY lvl.data_group_id, lvl_description

Line 561: FROM IGS_PE_PRIV_LEVEL lvl, IGS_PE_DATA_GROUPS DG

557: ln_data_Group_Id NUMBER(15);
558:
559: CURSOR cur_lvl_data_group (lnpersonid number) IS
560: SELECT max(dg.lvl) Max_Level, lvl.DATA_GROUP_ID , dg.lvl_description
561: FROM IGS_PE_PRIV_LEVEL lvl, IGS_PE_DATA_GROUPS DG
562: WHERE lvl.person_id = lnpersonid
563: AND TRUNC(SYSDATE) BETWEEN lvl.start_date AND NVL(lvl.end_date,TRUNC(SYSDATE))
564: and lvl.DATA_GROUP_ID = DG.DATA_GROUP_ID
565: GROUP BY lvl.data_group_id ,dg.lvl_description