eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_RS_GROUP_DENORM_PVT dependencies on JTF_RS_GROUPS_VL

Line 15: ( p_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

11: g_pkg_name varchar2(30) := 'JTF_RS_GROUP_DENORM_PVT';
12:
13: ------- USED ONLY BY "NO CONNECT BY" SECTION - BEGIN
14: TYPE REL_RECORD_TYPE IS RECORD
15: ( p_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
16: p_related_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
17: p_start_date_active DATE,
18: p_end_date_active DATE,
19: level NUMBER);

Line 16: p_related_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

12:
13: ------- USED ONLY BY "NO CONNECT BY" SECTION - BEGIN
14: TYPE REL_RECORD_TYPE IS RECORD
15: ( p_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
16: p_related_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
17: p_start_date_active DATE,
18: p_end_date_active DATE,
19: level NUMBER);
20:

Line 27: FUNCTION getDirectParent(p_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

23: g_parent_tab rel_table;
24: g_child_tab rel_table;
25:
26:
27: FUNCTION getDirectParent(p_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
28: p_level JTF_RS_GROUPS_DENORM.DENORM_LEVEL%type,
29: p_parent_group_id JTF_RS_GROUPS_DENORM.parent_group_id%type,
30: p_start_date JTF_RS_GROUPS_DENORM.start_date_active%TYPE,
31: p_end_date JTF_RS_GROUPS_DENORM.end_date_active%TYPE) RETURN NUMBER

Line 102: p_group_relate_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

98: PROCEDURE DELETE_GRP_RELATIONS_NO_CON(
99: P_API_VERSION IN NUMBER,
100: P_INIT_MSG_LIST IN VARCHAR2,
101: P_COMMIT IN VARCHAR2,
102: p_group_relate_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
103: p_group_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
104: p_related_group_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
105: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
106: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 103: p_group_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

99: P_API_VERSION IN NUMBER,
100: P_INIT_MSG_LIST IN VARCHAR2,
101: P_COMMIT IN VARCHAR2,
102: p_group_relate_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
103: p_group_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
104: p_related_group_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
105: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
106: X_MSG_COUNT OUT NOCOPY NUMBER,
107: X_MSG_DATA OUT NOCOPY VARCHAR2);

Line 104: p_related_group_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

100: P_INIT_MSG_LIST IN VARCHAR2,
101: P_COMMIT IN VARCHAR2,
102: p_group_relate_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
103: p_group_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
104: p_related_group_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
105: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
106: X_MSG_COUNT OUT NOCOPY NUMBER,
107: X_MSG_DATA OUT NOCOPY VARCHAR2);
108:

Line 137: CURSOR c_dup(x_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

133: X_MSG_COUNT OUT NOCOPY NUMBER,
134: X_MSG_DATA OUT NOCOPY VARCHAR2 )
135: IS
136:
137: CURSOR c_dup(x_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
138: x_parent_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE)
139: IS
140: SELECT den.group_id
141: FROM jtf_rs_groups_denorm den

Line 138: x_parent_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE)

134: X_MSG_DATA OUT NOCOPY VARCHAR2 )
135: IS
136:
137: CURSOR c_dup(x_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
138: x_parent_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE)
139: IS
140: SELECT den.group_id
141: FROM jtf_rs_groups_denorm den
142: WHERE den.group_id = x_group_id

Line 149: CURSOR c_date(x_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE)

145: /*
146: AND den.start_date_active = l_start_date
147: AND den.end_date_active = l_end_date; */
148:
149: CURSOR c_date(x_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE)
150: IS
151: SELECT grp.start_date_active,
152: grp.end_date_active
153: FROM jtf_rs_groups_b grp

Line 451: CURSOR c_parents(x_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE)

447: X_MSG_COUNT OUT NOCOPY NUMBER,
448: X_MSG_DATA OUT NOCOPY VARCHAR2 )
449: IS
450:
451: CURSOR c_parents(x_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE)
452: IS
453: SELECT rel.group_id,
454: rel.related_group_id,
455: rel.start_date_active,

Line 469: CURSOR c_date(x_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE)

465: AND NVL(rel.delete_flag, 'N') <> 'Y';
466:
467: r_parents c_parents%rowtype;
468:
469: CURSOR c_date(x_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE)
470: IS
471: SELECT grp.start_date_active,
472: grp.end_date_active
473: FROM jtf_rs_groups_b grp

Line 476: CURSOR c_dup(x_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

472: grp.end_date_active
473: FROM jtf_rs_groups_b grp
474: WHERE group_id = x_group_id;
475:
476: CURSOR c_dup(x_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
477: x_parent_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
478: l_start_date_active date,
479: l_end_date_active date)
480: IS

Line 477: x_parent_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

473: FROM jtf_rs_groups_b grp
474: WHERE group_id = x_group_id;
475:
476: CURSOR c_dup(x_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
477: x_parent_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
478: l_start_date_active date,
479: l_end_date_active date)
480: IS
481: SELECT den.group_id

Line 494: CURSOR c_child(x_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

490: OR ((l_start_date_active <= den.start_date_active)
491: AND (l_end_date_active >= den.end_date_active
492: OR l_end_date_active IS NULL)));
493:
494: CURSOR c_child(x_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
495: l_start_date date,
496: l_end_date date)
497: IS
498: SELECT rel.group_id,

Line 531: ( p_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

527: cb_p_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE := p_group_id;
528: ---------------------------------------------------------
529:
530: TYPE CHILD_TYPE IS RECORD
531: ( p_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
532: p_related_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
533: p_start_date_active DATE,
534: p_end_date_active DATE,
535: level NUMBER);

Line 532: p_related_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

528: ---------------------------------------------------------
529:
530: TYPE CHILD_TYPE IS RECORD
531: ( p_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
532: p_related_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
533: p_start_date_active DATE,
534: p_end_date_active DATE,
535: level NUMBER);
536:

Line 1226: CURSOR c_child(x_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE)

1222: X_MSG_COUNT OUT NOCOPY NUMBER,
1223: X_MSG_DATA OUT NOCOPY VARCHAR2 )
1224: IS
1225:
1226: CURSOR c_child(x_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE)
1227: IS
1228: SELECT rel.group_id,
1229: rel.related_group_id,
1230: rel.start_date_active,

Line 1242: CURSOR c_group_denorm(l_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE)

1238: AND NVL(rel.delete_flag, 'N') <> 'Y';
1239:
1240:
1241:
1242: CURSOR c_group_denorm(l_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE)
1243: IS
1244: SELECT denorm_grp_id,
1245: group_id,
1246: parent_group_id

Line 1426: p_group_relate_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

1422: PROCEDURE DELETE_GRP_RELATIONS(
1423: P_API_VERSION IN NUMBER,
1424: P_INIT_MSG_LIST IN VARCHAR2,
1425: P_COMMIT IN VARCHAR2,
1426: p_group_relate_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
1427: p_group_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
1428: p_related_group_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
1429: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1430: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 1427: p_group_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

1423: P_API_VERSION IN NUMBER,
1424: P_INIT_MSG_LIST IN VARCHAR2,
1425: P_COMMIT IN VARCHAR2,
1426: p_group_relate_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
1427: p_group_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
1428: p_related_group_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
1429: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1430: X_MSG_COUNT OUT NOCOPY NUMBER,
1431: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 1428: p_related_group_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

1424: P_INIT_MSG_LIST IN VARCHAR2,
1425: P_COMMIT IN VARCHAR2,
1426: p_group_relate_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
1427: p_group_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
1428: p_related_group_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
1429: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1430: X_MSG_COUNT OUT NOCOPY NUMBER,
1431: X_MSG_DATA OUT NOCOPY VARCHAR2)
1432: is

Line 1451: ( p_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

1447:
1448: r_child c_child%rowtype;
1449:
1450: TYPE CHILD_TYPE IS RECORD
1451: ( p_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
1452: p_related_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
1453: p_start_date_active DATE,
1454: p_end_date_active DATE);
1455:

Line 1452: p_related_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

1448: r_child c_child%rowtype;
1449:
1450: TYPE CHILD_TYPE IS RECORD
1451: ( p_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
1452: p_related_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
1453: p_start_date_active DATE,
1454: p_end_date_active DATE);
1455:
1456:

Line 1498: ( p_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

1494:
1495: r_parent c_parent%rowtype;
1496:
1497: TYPE parent_TYPE IS RECORD
1498: ( p_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
1499: p_related_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
1500: p_start_date_active DATE,
1501: p_end_date_active DATE);
1502:

Line 1499: p_related_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

1495: r_parent c_parent%rowtype;
1496:
1497: TYPE parent_TYPE IS RECORD
1498: ( p_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
1499: p_related_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
1500: p_start_date_active DATE,
1501: p_end_date_active DATE);
1502:
1503:

Line 1880: CURSOR c_parents(x_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE)

1876: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1877: X_MSG_COUNT OUT NOCOPY NUMBER,
1878: X_MSG_DATA OUT NOCOPY VARCHAR2 )
1879: IS
1880: CURSOR c_parents(x_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE)
1881: IS
1882: SELECT rel.group_id,
1883: rel.related_group_id,
1884: rel.start_date_active,

Line 1898: CURSOR c_date(x_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE)

1894: AND NVL(rel.delete_flag, 'N') <> 'Y';
1895:
1896: r_parents c_parents%rowtype;
1897:
1898: CURSOR c_date(x_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE)
1899: IS
1900: SELECT grp.start_date_active,
1901: grp.end_date_active
1902: FROM jtf_rs_groups_b grp

Line 1905: CURSOR c_dup(x_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

1901: grp.end_date_active
1902: FROM jtf_rs_groups_b grp
1903: WHERE group_id = x_group_id;
1904:
1905: CURSOR c_dup(x_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
1906: x_parent_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
1907: l_start_date_active date,
1908: l_end_date_active date)
1909: IS

Line 1906: x_parent_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

1902: FROM jtf_rs_groups_b grp
1903: WHERE group_id = x_group_id;
1904:
1905: CURSOR c_dup(x_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
1906: x_parent_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
1907: l_start_date_active date,
1908: l_end_date_active date)
1909: IS
1910: SELECT den.group_id

Line 2280: p_group_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

2276: PROCEDURE DELETE_GROUPS(
2277: P_API_VERSION IN NUMBER,
2278: P_INIT_MSG_LIST IN VARCHAR2,
2279: P_COMMIT IN VARCHAR2,
2280: p_group_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
2281: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2282: X_MSG_COUNT OUT NOCOPY NUMBER,
2283: X_MSG_DATA OUT NOCOPY VARCHAR2)
2284: IS

Line 2285: CURSOR c_group_denorm(l_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE)

2281: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2282: X_MSG_COUNT OUT NOCOPY NUMBER,
2283: X_MSG_DATA OUT NOCOPY VARCHAR2)
2284: IS
2285: CURSOR c_group_denorm(l_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE)
2286: IS
2287: SELECT denorm_grp_id,
2288: parent_group_id
2289: FROM JTF_RS_GROUPS_DENORM

Line 2302: CURSOR c_child(x_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE)

2298: WHERE group_id = l_group_id
2299: AND parent_group_id = l_parent_group_id;
2300:
2301:
2302: CURSOR c_child(x_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE)
2303: IS
2304: SELECT rel.group_id,
2305: rel.related_group_id,
2306: rel.start_date_active,

Line 2322: ( p_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

2318:
2319: r_child c_child%rowtype;
2320:
2321: TYPE CHILD_TYPE IS RECORD
2322: ( p_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
2323: p_related_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
2324: p_start_date_active DATE,
2325: p_end_date_active DATE);
2326:

Line 2323: p_related_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

2319: r_child c_child%rowtype;
2320:
2321: TYPE CHILD_TYPE IS RECORD
2322: ( p_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
2323: p_related_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
2324: p_start_date_active DATE,
2325: p_end_date_active DATE);
2326:
2327:

Line 2644: CURSOR c_date(x_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE)

2640: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2641: X_MSG_COUNT OUT NOCOPY NUMBER,
2642: X_MSG_DATA OUT NOCOPY VARCHAR2 )
2643: IS
2644: CURSOR c_date(x_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE)
2645: IS
2646: SELECT grp.start_date_active,
2647: grp.end_date_active
2648: FROM jtf_rs_groups_b grp

Line 2651: CURSOR c_dup(x_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

2647: grp.end_date_active
2648: FROM jtf_rs_groups_b grp
2649: WHERE group_id = x_group_id;
2650:
2651: CURSOR c_dup(x_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
2652: x_parent_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
2653: l_start_date_active date,
2654: l_end_date_active date)
2655: IS

Line 2652: x_parent_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

2648: FROM jtf_rs_groups_b grp
2649: WHERE group_id = x_group_id;
2650:
2651: CURSOR c_dup(x_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
2652: x_parent_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
2653: l_start_date_active date,
2654: l_end_date_active date)
2655: IS
2656: SELECT den.group_id

Line 3330: CURSOR c_group_denorm(l_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE)

3326: X_MSG_DATA OUT NOCOPY VARCHAR2 )
3327: IS
3328:
3329:
3330: CURSOR c_group_denorm(l_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE)
3331: IS
3332: SELECT denorm_grp_id,
3333: group_id,
3334: parent_group_id

Line 3491: p_group_relate_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

3487: PROCEDURE DELETE_GRP_RELATIONS_NO_CON(
3488: P_API_VERSION IN NUMBER,
3489: P_INIT_MSG_LIST IN VARCHAR2,
3490: P_COMMIT IN VARCHAR2,
3491: p_group_relate_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
3492: p_group_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
3493: p_related_group_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
3494: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
3495: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 3492: p_group_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

3488: P_API_VERSION IN NUMBER,
3489: P_INIT_MSG_LIST IN VARCHAR2,
3490: P_COMMIT IN VARCHAR2,
3491: p_group_relate_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
3492: p_group_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
3493: p_related_group_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
3494: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
3495: X_MSG_COUNT OUT NOCOPY NUMBER,
3496: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 3493: p_related_group_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

3489: P_INIT_MSG_LIST IN VARCHAR2,
3490: P_COMMIT IN VARCHAR2,
3491: p_group_relate_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
3492: p_group_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
3493: p_related_group_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
3494: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
3495: X_MSG_COUNT OUT NOCOPY NUMBER,
3496: X_MSG_DATA OUT NOCOPY VARCHAR2)
3497: is

Line 3844: CURSOR c_date(x_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE)

3840: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
3841: X_MSG_COUNT OUT NOCOPY NUMBER,
3842: X_MSG_DATA OUT NOCOPY VARCHAR2 )
3843: IS
3844: CURSOR c_date(x_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE)
3845: IS
3846: SELECT grp.start_date_active,
3847: grp.end_date_active
3848: FROM jtf_rs_groups_b grp

Line 3851: CURSOR c_dup(x_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

3847: grp.end_date_active
3848: FROM jtf_rs_groups_b grp
3849: WHERE group_id = x_group_id;
3850:
3851: CURSOR c_dup(x_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
3852: x_parent_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
3853: l_start_date_active date,
3854: l_end_date_active date)
3855: IS

Line 3852: x_parent_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

3848: FROM jtf_rs_groups_b grp
3849: WHERE group_id = x_group_id;
3850:
3851: CURSOR c_dup(x_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
3852: x_parent_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
3853: l_start_date_active date,
3854: l_end_date_active date)
3855: IS
3856: SELECT den.group_id