APPS.JAI_CMN_MTAX_PKG dependencies on JAI_CMN_BOE_HDRS

Line 393: FROM jai_cmn_boe_hdrs

389: --Added by zhiwei for BOE ER bug 11684111 begin
390: -----------------------------------------
391: CURSOR c_boe_header( p_document_type IN VARCHAR2, p_boe_no IN VARCHAR2, p_org_id IN NUMBER) IS
392: SELECT boe_id
393: FROM jai_cmn_boe_hdrs
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

Line 869: from jai_cmn_boe_hdrs head,

865: head.boe_date,
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 ))

Line 896: from jai_cmn_boe_hdrs head

892:
893: CURSOR chk_boe_rounding(cv_document_no VARCHAR2)
894: is
895: select count(rowid)
896: from jai_cmn_boe_hdrs head
897: where boe_id = to_number(cv_document_no)
898: and exists
899: (
900: select 1

Line 4507: UPDATE JAI_CMN_BOE_HDRS SET BOE_AMOUNT = ln_boe_amount

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
4508: WHERE BOE_ID IN
4509: (
4510: SELECT BOE_ID FROM JAI_BOE_DETAILS WHERE BOE_DETAIL_ID = boe_rec.boe_detail_id
4511: );