APPS.JAI_CMN_MTAX_PKG dependencies on JAI_BOE_DETAILS

Line 398: FROM jai_boe_details

394: WHERE boe_id = to_number(p_boe_no);
395:
396: CURSOR c_boe_line( p_boe_id IN NUMBER, p_boe_line_no IN NUMBER) IS
397: SELECT boe_detail_id
398: FROM jai_boe_details
399: WHERE boe_id = p_boe_id AND detail_line_num = p_boe_line_no;
400:
401:
402: ln_boe_tax_amount number;

Line 870: jai_boe_details detail

866: head.creation_date,
867: head.boe_id document_no,
868: detail.boe_detail_id line_number
869: from jai_cmn_boe_hdrs head,
870: jai_boe_details detail
871: where head.boe_id = detail.boe_id
872: AND ((p_document_no is null) OR (p_document_no is not null and head.boe_id = p_document_no ))
873: AND ((p_document_line_no IS NULL) OR (p_document_line_no IS NOT NULL AND detail.detail_line_num = p_document_line_no ))
874: AND ((p_vendor_id IS NULL)

Line 4483: UPDATE JAI_BOE_DETAILS

4479: where NVL(BOE_FLAG,'N')='Y'
4480: and BOE_DETAIL_ID = boe_rec.boe_detail_id;
4481:
4482:
4483: UPDATE JAI_BOE_DETAILS
4484: SET tax_amount = ln_boe_amount,
4485: last_update_date = SYSDATE,
4486: last_updated_by = v_user_id,
4487: last_update_login = v_login_id,

Line 4500: FROM JAI_BOE_DETAILS

4496: AND BOE_DETAIL_ID
4497: IN
4498: (
4499: SELECT BOE_DETAIL_ID
4500: FROM JAI_BOE_DETAILS
4501: WHERE BOE_ID IN
4502: (
4503: SELECT distinct BOE_ID FROM JAI_BOE_DETAILS WHERE BOE_DETAIL_ID = boe_rec.boe_detail_id
4504: )

Line 4503: SELECT distinct BOE_ID FROM JAI_BOE_DETAILS WHERE BOE_DETAIL_ID = boe_rec.boe_detail_id

4499: SELECT BOE_DETAIL_ID
4500: FROM JAI_BOE_DETAILS
4501: WHERE BOE_ID IN
4502: (
4503: SELECT distinct BOE_ID FROM JAI_BOE_DETAILS WHERE BOE_DETAIL_ID = boe_rec.boe_detail_id
4504: )
4505: );
4506: --Update boe head table
4507: UPDATE JAI_CMN_BOE_HDRS SET BOE_AMOUNT = ln_boe_amount

Line 4510: SELECT BOE_ID FROM JAI_BOE_DETAILS WHERE BOE_DETAIL_ID = boe_rec.boe_detail_id

4506: --Update boe head table
4507: UPDATE JAI_CMN_BOE_HDRS SET BOE_AMOUNT = ln_boe_amount
4508: WHERE BOE_ID IN
4509: (
4510: SELECT BOE_ID FROM JAI_BOE_DETAILS WHERE BOE_DETAIL_ID = boe_rec.boe_detail_id
4511: );
4512:
4513:
4514: