DBA Data[Home] [Help]

APPS.JTF_RS_WF_INTEGRATION_PUB dependencies on JTF_RS_GROUPS_VL

Line 1235: FROM JTF_RS_GROUPS_VL WHERE GROUP_ID = P_GROUP_ID;

1231: ORIG_SYSTEM = P_ORG_SYS;
1232:
1233: CURSOR C_GRP_OLD_VALS(P_GROUP_ID IN NUMBER) IS
1234: SELECT EMAIL_ADDRESS, GROUP_NAME, trunc(START_DATE_ACTIVE) START_DATE_ACTIVE, trunc(END_DATE_ACTIVE) END_DATE_ACTIVE
1235: FROM JTF_RS_GROUPS_VL WHERE GROUP_ID = P_GROUP_ID;
1236:
1237: l_old_grp_vals C_GRP_OLD_VALS%ROWTYPE;
1238: l_check_role varchar2(1);
1239: