APPS.JTF_RS_GROUP_RELATE_PVT dependencies on JTF_RS_GROUPS_B

Line 111: FROM jtf_rs_groups_b grp

107: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
108: l_end_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE)
109: IS
110: SELECT 'X'
111: FROM jtf_rs_groups_b grp
112: WHERE grp.group_id = l_group_id
113: -- changed by nsinghai 20 May 2002 to handle null value of l_end_date_active
114: -- AND l_start_date_active >= grp.start_date_active
115: -- AND ((grp.end_date_active IS NULL)

Line 126: CURSOR check_dates_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE ,

122:
123: check_group_dt_rec check_group_dt_cur%rowtype;
124:
125:
126: CURSOR check_dates_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE ,
127: l_related_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE )
128: IS
129: SELECT 'X'
130: FROM jtf_rs_groups_b g1

Line 127: l_related_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE )

123: check_group_dt_rec check_group_dt_cur%rowtype;
124:
125:
126: CURSOR check_dates_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE ,
127: l_related_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE )
128: IS
129: SELECT 'X'
130: FROM jtf_rs_groups_b g1
131: ,jtf_rs_groups_b g2

Line 130: FROM jtf_rs_groups_b g1

126: CURSOR check_dates_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE ,
127: l_related_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE )
128: IS
129: SELECT 'X'
130: FROM jtf_rs_groups_b g1
131: ,jtf_rs_groups_b g2
132: WHERE g1.group_id = l_group_id
133: AND g2.group_id = l_related_group_id
134: AND ((g1.start_date_active <= g2.end_date_active and g2.end_date_active <> NULL)

Line 131: ,jtf_rs_groups_b g2

127: l_related_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE )
128: IS
129: SELECT 'X'
130: FROM jtf_rs_groups_b g1
131: ,jtf_rs_groups_b g2
132: WHERE g1.group_id = l_group_id
133: AND g2.group_id = l_related_group_id
134: AND ((g1.start_date_active <= g2.end_date_active and g2.end_date_active <> NULL)
135: or ((g2.end_date_active IS NULL) AND (g1.end_date_active <> NULL) AND

Line 942: FROM jtf_rs_groups_b grp

938: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
939: l_end_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE)
940: IS
941: SELECT 'X'
942: FROM jtf_rs_groups_b grp
943: WHERE grp.group_id = l_group_id
944: -- changed by nsinghai 20 May 2002 to handle null value of l_end_date_active
945: -- AND l_start_date_active >= grp.start_date_active
946: -- AND ((grp.end_date_active IS NULL)

Line 957: CURSOR check_dates_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE ,

953:
954: check_group_dt_rec check_group_dt_cur%rowtype;
955:
956:
957: CURSOR check_dates_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE ,
958: l_related_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE )
959: IS
960: SELECT 'X'
961: FROM jtf_rs_groups_b g1

Line 958: l_related_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE )

954: check_group_dt_rec check_group_dt_cur%rowtype;
955:
956:
957: CURSOR check_dates_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE ,
958: l_related_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE )
959: IS
960: SELECT 'X'
961: FROM jtf_rs_groups_b g1
962: ,jtf_rs_groups_b g2

Line 961: FROM jtf_rs_groups_b g1

957: CURSOR check_dates_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE ,
958: l_related_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE )
959: IS
960: SELECT 'X'
961: FROM jtf_rs_groups_b g1
962: ,jtf_rs_groups_b g2
963: WHERE g1.group_id = l_group_id
964: AND g2.group_id = l_related_group_id
965: AND ((g1.start_date_active <= g2.end_date_active and g2.end_date_active <> NULL)

Line 962: ,jtf_rs_groups_b g2

958: l_related_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE )
959: IS
960: SELECT 'X'
961: FROM jtf_rs_groups_b g1
962: ,jtf_rs_groups_b g2
963: WHERE g1.group_id = l_group_id
964: AND g2.group_id = l_related_group_id
965: AND ((g1.start_date_active <= g2.end_date_active and g2.end_date_active <> NULL)
966: or ((g2.end_date_active IS NULL) AND (g1.end_date_active <> NULL) AND