APPS.ASO_VALIDATE_PVT dependencies on JTF_RS_REP_MANAGERS

Line 5930: from jtf_rs_rep_managers mgr,

5926: FROM jtf_rs_groups_denorm jrgd,
5927: jtf_rs_group_usages jrgu
5928: WHERE jrgd.parent_group_id IN (
5929: select u.group_id
5930: from jtf_rs_rep_managers mgr,
5931: jtf_rs_group_usages u
5932: where mgr.parent_resource_id = p_resource_id
5933: and trunc(sysdate) between trunc(mgr.start_date_active)
5934: and trunc(nvl(mgr.end_date_active,sysdate))

Line 5982: FROM jtf_rs_rep_managers MGR ,

5978: Cursor C_Mgr_Check Is --to check the manager flag
5979: select 1 from dual where exists
5980: (
5981: SELECT MGR.group_id
5982: FROM jtf_rs_rep_managers MGR ,
5983: jtf_rs_group_usages U
5984: WHERE U.usage = 'SALES'
5985: AND U.group_id = MGR.group_id
5986: AND trunc(MGR.start_date_active) <= trunc(SYSDATE)

Line 6365: FROM jtf_rs_rep_managers MGR ,

6361: Cursor C_Mgr_Check Is --to check the manager flag
6362: select 1 from DUAL where exists
6363: (
6364: SELECT MGR.group_id
6365: FROM jtf_rs_rep_managers MGR ,
6366: jtf_rs_group_usages U
6367: WHERE U.usage = 'SALES'
6368: AND U.group_id = MGR.group_id
6369: AND TRUNC(MGR.start_date_active) <= trunc(SYSDATE)

Line 6453: from jtf_rs_rep_managers mgr,

6449: FROM jtf_rs_groups_denorm jrgd,
6450: jtf_rs_group_usages jrgu
6451: WHERE jrgd.parent_group_id IN (
6452: select u.group_id
6453: from jtf_rs_rep_managers mgr,
6454: jtf_rs_group_usages u
6455: where mgr.parent_resource_id = p_resource_id
6456: and trunc(sysdate) between trunc(mgr.start_date_active)
6457: and trunc(nvl(mgr.end_date_active,sysdate))

Line 6808: FROM jtf_rs_rep_managers MGR ,

6804: Cursor C_Mgr_Check Is --to check the manager flag
6805: select 1 from dual where exists
6806: (
6807: SELECT MGR.group_id
6808: FROM jtf_rs_rep_managers MGR ,
6809: jtf_rs_group_usages U
6810: WHERE U.usage = 'SALES'
6811: AND U.group_id = MGR.group_id
6812: AND trunc(MGR.start_date_active) <= trunc(SYSDATE)

Line 6974: from jtf_rs_rep_managers mgr,

6970: FROM jtf_rs_groups_denorm jrgd,
6971: jtf_rs_group_usages jrgu
6972: WHERE jrgd.parent_group_id IN (
6973: select u.group_id
6974: from jtf_rs_rep_managers mgr,
6975: jtf_rs_group_usages u
6976: where mgr.parent_resource_id = p_resource_id
6977: and trunc(sysdate) between trunc(mgr.start_date_active)
6978: and trunc(nvl(mgr.end_date_active,sysdate))

Line 7687: FROM jtf_rs_rep_managers MGR ,

7683: Cursor C_Mgr_Check Is --to check the manager flag
7684: select 1 from dual where exists
7685: (
7686: SELECT MGR.group_id
7687: FROM jtf_rs_rep_managers MGR ,
7688: jtf_rs_group_usages U
7689: WHERE U.usage = 'SALES'
7690: AND U.group_id = MGR.group_id
7691: AND trunc(MGR.start_date_active) <= trunc(SYSDATE)

Line 7761: from jtf_rs_rep_managers mgr,

7757: FROM jtf_rs_groups_denorm jrgd,
7758: jtf_rs_group_usages jrgu
7759: WHERE jrgd.parent_group_id IN (
7760: select U.group_id
7761: from jtf_rs_rep_managers mgr,
7762: jtf_rs_group_usages u
7763: where mgr.parent_resource_id = p_resource_id
7764: and trunc(sysdate) between trunc(mgr.start_date_active) and trunc(nvl(mgr.end_date_active,sysdate))
7765: and mgr.hierarchy_type = 'MGR_TO_REP'