APPS.PAYWSDYG_PKG dependencies on PAY_TRIGGER_SUPPORT

Line 367: SELECT pay_trigger_support_s.NEXTVAL

363: ) RETURN NUMBER IS
364: --
365: -- Fetch the next value from the primary key generating sequence
366: CURSOR get_id IS
367: SELECT pay_trigger_support_s.NEXTVAL
368: FROM dual;
369: --
370: l_rc NUMBER;
371: --

Line 380: INSERT INTO pay_trigger_support(

376: FETCH get_id INTO l_rc;
377: CLOSE get_id;
378: --
379: -- Insert the data into the table
380: INSERT INTO pay_trigger_support(
381: support_id,
382: event_id,
383: header_code,
384: body_code

Line 1214: FROM pay_trigger_support

1210: --
1211: -- Fetch the last saved version of the code from the database table
1212: CURSOR get_old(cp_id IN NUMBER) IS
1213: SELECT header_code,body_code
1214: FROM pay_trigger_support
1215: WHERE support_id = cp_id;
1216: --
1217: l_h CLOB;
1218: l_b CLOB;

Line 1835: pay_trigger_support pts

1831: pte.table_name,
1832: pts.header_code,
1833: pts.body_code
1834: FROM pay_trigger_events pte,
1835: pay_trigger_support pts
1836: WHERE pte.event_id = pts.event_id
1837: AND pts.support_id = cp_id;
1838: --
1839: l_id NUMBER;

Line 2584: FROM pay_trigger_support

2580: --
2581: -- Drop the support package and delete it's definition
2582: drop_package(l_tname,get_package_name(p_id,l_tname));
2583: DELETE
2584: FROM pay_trigger_support
2585: WHERE event_id = p_id;
2586: --
2587: -- Don't delete the actual event, the caller (e.g. Forms) must do this
2588: END delete_event_children;