APPS.JAI_BOE_MIGRATION_PKG dependencies on JAI_CMN_BOE_HDRS_ALL

Line 139: FROM jai_cmn_boe_hdrs_all

135: ,AMOUNT_APPLIED
136: ,AMOUNT_WRITTEN_OFF
137: ,INVOICE_NUM,
138: CONSOLIDATED_FLAG
139: FROM jai_cmn_boe_hdrs_all
140: WHERE boe_id = pn_boe_id;
141:
142: boe_hdr_rec boe_hdr_cur%ROWTYPE;
143:

Line 267: UPDATE jai_cmn_boe_hdrs_all SET

263: ELSIF nvl(boe_invoice_payment_status,'N') = 'Y' AND nvl(pn_amount_applied,0) > 0 THEN
264: boe_status := 'APPLIED';
265: END IF;--nvl(boe_invoice_payment_status ,'N') = 'N'
266:
267: UPDATE jai_cmn_boe_hdrs_all SET
268: status = boe_status,
269: migration_flag = 'Y',
270: org_id = pn_org_id,
271: BOE_WITHOUT_REFER_FLAG = decode(CONSOLIDATED_FLAG,'Y',NULL,'N','Y'),

Line 1128: FROM JAI_CMN_BOE_HDRS_ALL hdr,

1124: hdr.AMOUNT_WRITTEN_OFF,
1125: hdr.status,
1126: hdr.migration_flag,
1127: OU.ORGANIZATION_ID OU_ID
1128: FROM JAI_CMN_BOE_HDRS_ALL hdr,
1129: org_organization_definitions INV,
1130: hr_all_organization_units OU
1131: WHERE INV.operating_unit = OU.organization_id
1132: AND INV.organization_id = hdr.organization_id

Line 1429: jai_cmn_boe_hdrs_all hdr

1425: SELECT org.boe_account_id boe_account,
1426: hdr.organization_id,
1427: hdr.location_id
1428: FROM JAI_CMN_INVENTORY_ORGS org,
1429: jai_cmn_boe_hdrs_all hdr
1430: WHERE org.organization_id = hdr.organization_id
1431: AND org.location_id = hdr.location_id
1432: AND hdr.boe_id = v_boe_id;
1433: