APPS.JTF_RS_CONC_GRP_DENORM_PUB dependencies on JTF_RS_CHGD_GRP_RELATIONS

Line 7: in JTF_RS_CHGD_GRP_RELATIONS Table. This is the intermidiate table which will keep all

3:
4:
5: /*****************************************************************************************
6: This is a concurrent program to fetch all the records which are avaialble in
7: in JTF_RS_CHGD_GRP_RELATIONS Table. This is the intermidiate table which will keep all
8: the records which have to be updated / deleted / inserted in JTF_RS_GROUP_RELATIONS.
9: After successful processing the row will be deleted from JTF_RS_CHGD_GRP_RELATIONS.
10:
11: ******************************************************************************************/

Line 9: After successful processing the row will be deleted from JTF_RS_CHGD_GRP_RELATIONS.

5: /*****************************************************************************************
6: This is a concurrent program to fetch all the records which are avaialble in
7: in JTF_RS_CHGD_GRP_RELATIONS Table. This is the intermidiate table which will keep all
8: the records which have to be updated / deleted / inserted in JTF_RS_GROUP_RELATIONS.
9: After successful processing the row will be deleted from JTF_RS_CHGD_GRP_RELATIONS.
10:
11: ******************************************************************************************/
12:
13:

Line 43: FROM JTF_RS_CHGD_GRP_RELATIONS

39: related_group_id,
40: relation_type,
41: operation_flag,
42: rowid row_id
43: FROM JTF_RS_CHGD_GRP_RELATIONS
44: ORDER BY creation_date;
45: -- FOR UPDATE OF group_relate_id;
46:
47: BEGIN

Line 159: DELETE FROM JTF_RS_CHGD_GRP_RELATIONS

155: END IF;
156:
157: -- After sucessful completion delete the row
158:
159: DELETE FROM JTF_RS_CHGD_GRP_RELATIONS
160: WHERE group_relate_id = l_grp.group_relate_id
161: AND rowid = l_grp.row_id ;
162: -- WHERE CURRENT OF c_get_grp ;
163: