[Home] [Help]
1073:
1074: /* cursor to select all the eligible invoices exclude manual modified transactions in JAI_FBT_REPOSITORY
1075: The invoice to be eligible for FBT should meet the following criteria
1076: 1) invoice should be of type
1077: ('STANDARD','DEBIT', 'CREDIT', 'EXPENSE REPORT','MIXED')
1078: 2) invoice should be validated invoice
1079: 3) only non-recoverable tax lines are eligible for FBT
1080: 4) match the criteria entered by the user in CP parameters form
1081: 5) do not re-fetch transactions that have been modified in JAI_FBT_REPOSITORY
1128: --------------------------------------------------------------
1129: -- Modified by Jia for bug#7675638 on 30-Dec-2008, End
1130:
1131: AND det.po_distribution_id = po.po_distribution_id
1132: AND invoice_type_lookup_code IN ( 'STANDARD'
1133: , 'DEBIT'
1134: , 'CREDIT'
1135: , 'EXPENSE REPORT'
1136: ,'MIXED'
1241: AND head.legal_entity_id = pn_legal_entity_id
1242: --------------------------------------------------------------
1243: -- Modified by Jia for bug#7675638 on 30-Dec-2008, End
1244:
1245: AND invoice_type_lookup_code IN ( 'STANDARD'
1246: , 'DEBIT'
1247: , 'CREDIT'
1248: , 'EXPENSE REPORT'
1249: , 'MIXED'
1433: , 'Enter procedure'
1434: );
1435: END IF; --l_proc_level>=l_dbg_level
1436:
1437: -- the source date format like '2007/06/01 00:00:00', format it to standard format
1438: ld_start_date := TRUNC(fnd_date.canonical_to_date (pv_start_date));
1439: ld_end_date := TRUNC(fnd_date.canonical_to_date (pv_end_date));
1440:
1441: -- ld_start_date := TO_DATE(pv_start_date, GV_DATE_MASK);