APPS.INV_THIRD_PARTY_STOCK_PVT dependencies on ZX_REC_NREC_DIST_GT

Line 490: zx_rec_nrec_dist_gt

486: CURSOR tax_csr_type_nrec IS
487: SELECT
488: SUM(NVL( rec_nrec_tax_amt,0))
489: FROM
490: zx_rec_nrec_dist_gt
491: WHERE application_id = 201
492: AND entity_code = l_entity_code
493: AND trx_id = p_header_id
494: AND event_class_code = l_event_class_code

Line 501: zx_rec_nrec_dist_gt

497: CURSOR tax_csr_type_rec IS
498: SELECT
499: SUM(NVL( rec_nrec_tax_amt,0))
500: FROM
501: zx_rec_nrec_dist_gt
502: WHERE application_id = 201
503: AND entity_code = l_entity_code
504: AND trx_id = p_header_id
505: AND event_class_code = l_event_class_code

Line 515: zx_rec_nrec_dist_gt

511: SELECT
512: rec_nrec_rate
513: , tax_rate
514: FROM
515: zx_rec_nrec_dist_gt
516: WHERE application_id = 201
517: AND entity_code = l_entity_code
518: AND trx_id = p_header_id
519: AND event_class_code = l_event_class_code

Line 1010: DELETE FROM zx_rec_nrec_dist_gt

1006:
1007: /*Fix#7120486 end */
1008:
1009: /*5488006 - Start */
1010: DELETE FROM zx_rec_nrec_dist_gt
1011: WHERE application_id = 201
1012: AND entity_code = l_entity_code
1013: AND trx_id = p_header_id
1014: AND event_class_code = l_event_class_code ;