APPS.JTF_RS_GROUP_RELATE_PVT dependencies on JTF_RS_GROUPS_DENORM

Line 148: from jtf_rs_groups_denorm

144: l_start_date_active date,
145: l_end_date_active date)
146: is
147: select 'x'
148: from jtf_rs_groups_denorm
149: where parent_group_id = l_group_id
150: and group_id = l_related_group_id
151: and ( ( (l_start_date_active >= start_date_active)
152: AND ((l_start_date_active <= end_date_active)

Line 493: X_LAST_UPDATE_LOGIN => l_login_id); --call to insert records in jtf_rs_groups_denorm

489: X_CREATION_DATE => l_date,
490: X_CREATED_BY => l_user_id,
491: X_LAST_UPDATE_DATE => l_date,
492: X_LAST_UPDATED_BY => l_user_id,
493: X_LAST_UPDATE_LOGIN => l_login_id); --call to insert records in jtf_rs_groups_denorm
494: IF(l_relation_type = 'PARENT_GROUP')
495: THEN
496:
497: l_parent := 0;

Line 980: from jtf_rs_groups_denorm

976: l_start_date_active date,
977: l_end_date_active date)
978: is
979: select 'x'
980: from jtf_rs_groups_denorm
981: where parent_group_id = l_group_id
982: and group_id = l_related_group_id
983: and ( ( (l_start_date_active >= start_date_active)
984: AND ((l_start_date_active <= end_date_active)

Line 1470: --call to insert records in jtf_rs_groups_denorm FOR UPDATION EFFECT

1466: p_object_version_num := l_object_version_number;
1467:
1468:
1469:
1470: --call to insert records in jtf_rs_groups_denorm FOR UPDATION EFFECT
1471: IF(l_relation_type = 'PARENT_GROUP')
1472: THEN
1473: IF (l_start_date_active <> grp_rel_rec.start_date_active
1474: OR nvl(l_end_date_active, fnd_api.g_miss_date) <>

Line 2032: --call to delete records in jtf_rs_groups_denorm

2028:
2029:
2030:
2031:
2032: --call to delete records in jtf_rs_groups_denorm
2033: IF(grp_rel_rec.relation_type = 'PARENT_GROUP')
2034: THEN
2035: l_parent := 0;
2036: l_child := 0;