APPS.ZPB_EXCEPTION_ALERT dependencies on ZPB_EXCP_EXPLANATIONS

Line 1531: -- delete ZPB_EXCP_EXPLANATIONS

1527:
1528: -- delete ZPB_EXCP_RESULTS
1529: -- where TASK_ID = taskID;
1530:
1531: -- delete ZPB_EXCP_EXPLANATIONS
1532: -- where TASK_ID = taskID;
1533:
1534: -- commit;
1535:

Line 2143: from ZPB_EXCP_EXPLANATIONS

2139:
2140:
2141: CURSOR c_thisowner is
2142: select distinct OWNER, OWNER_ID, APPROVER, APPROVER_ID
2143: from ZPB_EXCP_EXPLANATIONS
2144: where TASK_ID = TaskID and Notification_id = NID and STATUS = 2
2145: order by OWNER;
2146:
2147: v_thisowner c_thisowner%ROWTYPE;

Line 2520: from ZPB_EXCP_EXPLANATIONS

2516: l_dimname varchar2(100);
2517:
2518: CURSOR c_byowner is
2519: select *
2520: from ZPB_EXCP_EXPLANATIONS
2521: where TASK_ID = TaskID and
2522: NOTIFICATION_ID = nid and
2523: OWNER = DataOwner and
2524: status = 2;