APPS.JTF_RS_GROUP_DENORM_PVT dependencies on DUAL

Line 230: FROM dual;

226: --insert the record for the group with itself as the parent group
227:
228: SELECT jtf_rs_groups_denorm_s.nextval
229: INTO l_DENORM_GRP_ID
230: FROM dual;
231:
232: l_actual_parent_id := getDirectParent(p_group_id,
233: 0,
234: p_group_id,

Line 825: FROM dual;

821: THEN
822:
823: SELECT jtf_rs_groups_denorm_s.nextval
824: INTO l_denorm_grp_id
825: FROM dual;
826:
827:
828: l_actual_parent_id := getDirectParent(l_child_tab(i).p_group_id,
829: l_child_tab(i).level,

Line 953: FROM dual;

949: THEN
950:
951: SELECT jtf_rs_groups_denorm_s.nextval
952: INTO l_denorm_grp_id
953: FROM dual;
954:
955: l_actual_parent_id := getDirectParent(p_group_id,
956: r_parents.level,
957: r_parents.related_group_id,

Line 1069: FROM dual;

1065: THEN
1066:
1067: SELECT jtf_rs_groups_denorm_s.nextval
1068: INTO l_denorm_grp_id
1069: FROM dual;
1070:
1071: l_actual_parent_id := getDirectParent(l_child_tab(i).p_group_id,
1072: l_child_tab(i).level + r_parents.level,
1073: r_parents.related_group_id,

Line 2139: FROM dual;

2135: THEN
2136:
2137: SELECT jtf_rs_groups_denorm_s.nextval
2138: INTO l_denorm_grp_id
2139: FROM dual;
2140:
2141: l_actual_parent_id := getDirectParent(p_group_id,
2142: r_parents.level,
2143: r_parents.related_group_id,

Line 2945: FROM dual;

2941: THEN
2942:
2943: SELECT jtf_rs_groups_denorm_s.nextval
2944: INTO l_denorm_grp_id
2945: FROM dual;
2946:
2947:
2948: l_actual_parent_id := getDirectParent(l_child_tab(i).p_group_id,
2949: l_child_tab(i).level,

Line 3072: FROM dual;

3068: THEN
3069:
3070: SELECT jtf_rs_groups_denorm_s.nextval
3071: INTO l_denorm_grp_id
3072: FROM dual;
3073:
3074: l_actual_parent_id := getDirectParent(p_group_id,
3075: l_parent_tab(j).level,
3076: l_parent_tab(j).p_related_group_id,

Line 3187: FROM dual;

3183: THEN
3184:
3185: SELECT jtf_rs_groups_denorm_s.nextval
3186: INTO l_denorm_grp_id
3187: FROM dual;
3188:
3189: l_actual_parent_id := getDirectParent(l_child_tab(i).p_group_id,
3190: l_child_tab(i).level + l_parent_tab(j).level,
3191: l_parent_tab(j).p_related_group_id,

Line 4069: FROM dual;

4065: THEN
4066:
4067: SELECT jtf_rs_groups_denorm_s.nextval
4068: INTO l_denorm_grp_id
4069: FROM dual;
4070:
4071: l_actual_parent_id := getDirectParent(p_group_id,
4072: l_parent_tab(i).level,
4073: l_parent_tab(i).p_related_group_id,