APPS.INV_THIRD_PARTY_STOCK_PVT dependencies on ZX_REC_NREC_DIST_GT

Line 482: zx_rec_nrec_dist_gt

478: CURSOR tax_csr_type_nrec IS
479: SELECT
480: SUM(NVL( rec_nrec_tax_amt,0))
481: FROM
482: zx_rec_nrec_dist_gt
483: WHERE application_id = 201
484: AND entity_code = l_entity_code
485: AND trx_id = p_header_id
486: AND event_class_code = l_event_class_code

Line 493: zx_rec_nrec_dist_gt

489: CURSOR tax_csr_type_rec IS
490: SELECT
491: SUM(NVL( rec_nrec_tax_amt,0))
492: FROM
493: zx_rec_nrec_dist_gt
494: WHERE application_id = 201
495: AND entity_code = l_entity_code
496: AND trx_id = p_header_id
497: AND event_class_code = l_event_class_code

Line 507: zx_rec_nrec_dist_gt

503: SELECT
504: rec_nrec_rate
505: , tax_rate
506: FROM
507: zx_rec_nrec_dist_gt
508: WHERE application_id = 201
509: AND entity_code = l_entity_code
510: AND trx_id = p_header_id
511: AND event_class_code = l_event_class_code

Line 1000: DELETE FROM zx_rec_nrec_dist_gt

996:
997: /*Fix#7120486 end */
998:
999: /*5488006 - Start */
1000: DELETE FROM zx_rec_nrec_dist_gt
1001: WHERE application_id = 201
1002: AND entity_code = l_entity_code
1003: AND trx_id = p_header_id
1004: AND event_class_code = l_event_class_code ;