DBA Data[Home] [Help]

APPS.JTF_RS_WF_INTEGRATION_PUB dependencies on JTF_RS_TEAMS_VL

Line 1766: FROM JTF_RS_TEAMS_VL WHERE TEAM_ID = P_TEAM_ID;

1762: ORIG_SYSTEM = P_ORG_SYS;
1763:
1764: CURSOR C_TEAM_OLD_VALS(P_TEAM_ID IN NUMBER) IS
1765: SELECT EMAIL_ADDRESS, TEAM_NAME, trunc(START_DATE_ACTIVE) START_DATE_ACTIVE, trunc(END_DATE_ACTIVE) END_DATE_ACTIVE
1766: FROM JTF_RS_TEAMS_VL WHERE TEAM_ID = P_TEAM_ID;
1767:
1768: l_old_team_vals C_TEAM_OLD_VALS%ROWTYPE;
1769: l_check_role C_ROLE_EXISTS%ROWTYPE;
1770: