APPS.JAI_CMN_TAX_DEFAULTATION_PKG dependencies on JAI_PO_REQ_LINE_TAXES

Line 836: for c_req_tax_lines in (select * from JAI_PO_REQ_LINE_TAXES

832: */
833: if (transaction_name = 'PO_REQN' and (p_tax_category_id is null or ln_tax_modified_flag = 'Y')
834: and p_modified_by_agent_flag is NULL and p_parent_req_line_id is NOT NULL) then
835:
836: for c_req_tax_lines in (select * from JAI_PO_REQ_LINE_TAXES
837: where requisition_line_id = p_parent_req_line_id) loop
838:
839: /*Fetch quantity of parent line to populate taxes in child lines*/
840: ja_in_po_get_reqline_p(p_parent_req_line_id, ln_prev_quantity);

Line 847: insert into JAI_PO_REQ_LINE_TAXES(

843: from JAI_CMN_TAXES_ALL
844: where tax_id = c_req_tax_lines.tax_id;
845:
846: /*Insert Tax Lines for child lines based on Tax lines of the parent*/
847: insert into JAI_PO_REQ_LINE_TAXES(
848: requisition_line_id, requisition_header_id, tax_line_no,
849: precedence_1, precedence_2, precedence_3,
850: precedence_4, precedence_5,
851: precedence_6, precedence_7, precedence_8,

Line 3922: FROM JAI_PO_REQ_LINE_TAXES

3918: WHERE Tax_Id = taxid;
3919:
3920: CURSOR fetch_vendor2_cur IS
3921: SELECT vendor_id
3922: FROM JAI_PO_REQ_LINE_TAXES
3923: WHERE Requisition_Line_Id = ( SELECT Requisition_Line_Id
3924: FROM Po_Requisition_Lines_All
3925: WHERE Line_Location_Id = p_line_id );
3926:

Line 4170: INSERT INTO JAI_PO_REQ_LINE_TAXES(

4166: THEN /* Indiactes an Internal Requisition */
4167: v_vendor_id := p_operation_flag;
4168: END IF;
4169:
4170: INSERT INTO JAI_PO_REQ_LINE_TAXES(
4171: requisition_line_id, requisition_header_id, tax_line_no,
4172: precedence_1, precedence_2, precedence_3, precedence_4, precedence_5,
4173: precedence_6, precedence_7, precedence_8, precedence_9, precedence_10, -- Date 31/10/2006 Bug 5228046 added by SACSETHI
4174: tax_id, tax_rate, qty_rate, uom, tax_amount, Tax_Target_Amount,