APPS.CS_CHARGE_DETAILS_PVT dependencies on JTF_OBJECT_PURGE_PARAM_TMP

Line 16924: UPDATE jtf_object_purge_param_tmp

16920: -- if the charge lines are ACTUAL and do not have
16921: -- a line id attached to them, then the corresponding
16922: -- SRs cannot be purged.
16923:
16924: UPDATE jtf_object_purge_param_tmp
16925: SET
16926: purge_status = 'E'
16927: , purge_error_message = 'CS:CS_CHG_LINE_VAL_ERR'
16928: WHERE

Line 16935: , jtf_object_purge_param_tmp t

16931: SELECT
16932: t.object_id
16933: FROM
16934: cs_estimate_details e
16935: , jtf_object_purge_param_tmp t
16936: WHERE
16937: e.incident_id = t.object_id
16938: AND e.charge_line_type = 'ACTUAL'
16939: AND e.order_line_id IS NULL

Line 17186: -- bug 12681409 Change the hint to cardinality(jtf_object_purge_param_tmp, 10)

17182: END IF ;
17183:
17184: -- Delete all the estimate lines that correspond to the
17185: -- SRs that are available for purge after validations.
17186: -- bug 12681409 Change the hint to cardinality(jtf_object_purge_param_tmp, 10)
17187:
17188: DELETE /*+ index(e) */ cs_estimate_details e
17189: WHERE
17190: incident_id IN

Line 17192: SELECT /*+ cardinality(jtf_object_purge_param_tmp, 10) */

17188: DELETE /*+ index(e) */ cs_estimate_details e
17189: WHERE
17190: incident_id IN
17191: (
17192: SELECT /*+ cardinality(jtf_object_purge_param_tmp, 10) */
17193: object_id
17194: FROM
17195: jtf_object_purge_param_tmp
17196: WHERE

Line 17195: jtf_object_purge_param_tmp

17191: (
17192: SELECT /*+ cardinality(jtf_object_purge_param_tmp, 10) */
17193: object_id
17194: FROM
17195: jtf_object_purge_param_tmp
17196: WHERE
17197: processing_set_id = p_processing_set_id
17198: AND object_type = 'SR'
17199: AND NVL(purge_status, 'S') = 'S'