DBA Data[Home] [Help]

APPS.HRI_OLTP_DISC_TRAINING dependencies on OTA_PROGRAM_MEMBERSHIPS

Line 81: ,ota_program_memberships pm

77: ,tav.version_name
78: FROM
79: ota_activity_versions tav
80: ,ota_events evt
81: ,ota_program_memberships pm
82: WHERE evt.activity_version_id = tav.activity_version_id
83: AND evt.event_id = pm.event_id
84: AND pm.program_event_id = p_program_event_id;
85:

Line 182: FROM ota_program_memberships

178: l_business_group_id ota_events.business_group_id%type;
179:
180: CURSOR program_event_csr is
181: SELECT program_event_id
182: FROM ota_program_memberships
183: WHERE event_id = p_event_id;
184:
185: program_event_rec program_event_csr%rowtype;
186: l_budget_cost ota_events.budget_cost%type := 0;

Line 780: FROM ota_program_memberships

776: RETURN NUMBER IS
777:
778: CURSOR program_event_csr IS
779: SELECT program_event_id
780: FROM ota_program_memberships
781: WHERE event_id = p_event_id;
782:
783: program_event_rec program_event_csr%rowtype;
784: