APPS.JTF_TASK_AUDITS_PVT dependencies on JTF_TASK_AUDITS_B

Line 335: FROM jtf_task_audits_b

331:
332: CURSOR ta_cur1 (l_rowid IN ROWID)
333: IS
334: SELECT 1
335: FROM jtf_task_audits_b
336: WHERE ROWID = l_rowid;
337:
338: CURSOR c_audit
339: IS

Line 1392: FROM jtf_task_audits_b

1388:
1389: CURSOR ta_cur1 (l_rowid IN ROWID)
1390: IS
1391: SELECT 1
1392: FROM jtf_task_audits_b
1393: WHERE ROWID = l_rowid;
1394:
1395: CURSOR tsk_aud (p_task_id IN NUMBER)
1396: IS

Line 1848: cursor C is select ROWID from JTF_TASK_AUDITS_B

1844: X_NEW_DATE_SELECTED in VARCHAR2,
1845: X_OLD_LOCATION_ID in NUMBER,
1846: X_NEW_LOCATION_ID in NUMBER
1847: ) is
1848: cursor C is select ROWID from JTF_TASK_AUDITS_B
1849: where TASK_AUDIT_ID = X_TASK_AUDIT_ID
1850: ;
1851: begin
1852: insert into JTF_TASK_AUDITS_B (

Line 1852: insert into JTF_TASK_AUDITS_B (

1848: cursor C is select ROWID from JTF_TASK_AUDITS_B
1849: where TASK_AUDIT_ID = X_TASK_AUDIT_ID
1850: ;
1851: begin
1852: insert into JTF_TASK_AUDITS_B (
1853: NEW_NOTIFICATION_PERIOD,
1854: OLD_NOTIFICATION_PERIOD_UOM,
1855: NEW_NOTIFICATION_PERIOD_UOM,
1856: OLD_PARENT_TASK_ID,

Line 2110: from JTF_TASK_AUDITS_B B

2106:
2107: delete from JTF_TASK_AUDITS_TL T
2108: where not exists
2109: (select NULL
2110: from JTF_TASK_AUDITS_B B
2111: where B.TASK_AUDIT_ID = T.TASK_AUDIT_ID
2112: );
2113:
2114: update JTF_TASK_AUDITS_TL T set (