eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_PA_COSTING_PKG dependencies on JAI_PA_TAX_TRXS

Line 670: -- Post Processing Client Extension to update pa_addition_flag in jai_pa_tax_trxs to 'Y' if processed

666: end pre_process;
667:
668:
669: -- Added by Jia for FP Bug#9863751, Begin
670: -- Post Processing Client Extension to update pa_addition_flag in jai_pa_tax_trxs to 'Y' if processed
671: ----------------------------------------------------------------------------------------------------------------
672: procedure post_process
673: ( p_transaction_source in varchar2,
674: p_batch in varchar2,

Line 697: from jai_pa_tax_trxs

693: and (attribute10 <> 'INDIA LOCALIZATION' or attribute10 is NULL);
694:
695: cursor c_upd_req_id is
696: select *
697: from jai_pa_tax_trxs
698: where interface_id = p_xface_id
699: and transaction_source = p_transaction_source
700: for update of request_id;
701:

Line 730: update jai_pa_tax_trxs

726:
727: for r_pa_trx_xface_rec_status in c_pa_trx_xface_rec_status
728: loop
729:
730: update jai_pa_tax_trxs
731: set pa_addition_flag = 'Y',
732: expenditure_item_id = r_pa_trx_xface_rec_status.expenditure_item_id
733: where cdl_system_reference4 = r_pa_trx_xface_rec_status.cdl_system_reference4
734: and attribute9 = r_pa_trx_xface_rec_status.attribute9

Line 756: update jai_pa_tax_trxs

752: loop
753:
754: FND_FILE.put_line(FND_FILE.log, 'Updating Request ID: ' || fnd_global.conc_request_id());
755:
756: update jai_pa_tax_trxs
757: set request_id = fnd_global.conc_request_id()
758: where current of c_upd_req_id;
759: end loop; /*for r_upd_req_id in c_upd_req_id*/
760:

Line 809: a.tax_id , -- Added by Jia for FP Bug#9863751, fetched Tax ID to uniquely identify a line in jai_pa_tax_trxs

805: cp_attribute2 IN VARCHAR2,
806: cp_curr_conv_rate In NUMBER)
807: IS
808: select
809: a.tax_id , -- Added by Jia for FP Bug#9863751, fetched Tax ID to uniquely identify a line in jai_pa_tax_trxs
810: a.vendor_id , /*Added by nprashar for bug # 8691525*/
811: /* functional tax amount calc */
812: nvl(
813: decode(nvl(a.currency, 'INR'), 'INR',

Line 893: cursor c_jai_pa_tax_trxs is

889: /*Bug 8400140 - End*/
890:
891: -- Added by Jia for FP Bug#9863751, Begin
892: ----------------------------------------------------------------------------------------------------------------
893: cursor c_jai_pa_tax_trxs is
894: select *
895: from jai_pa_tax_trxs jait
896: where pa_addition_flag = 'N'
897: and expenditure_item_id is NULL

Line 895: from jai_pa_tax_trxs jait

891: -- Added by Jia for FP Bug#9863751, Begin
892: ----------------------------------------------------------------------------------------------------------------
893: cursor c_jai_pa_tax_trxs is
894: select *
895: from jai_pa_tax_trxs jait
896: where pa_addition_flag = 'N'
897: and expenditure_item_id is NULL
898: and batch_name = nvl(p_batch, batch_name)
899: and (request_id <> FND_GLOBAL.CONC_REQUEST_ID() or request_id is NULL)

Line 910: from jai_pa_tax_trxs

906: and pti.transaction_status_code = 'P');
907:
908: cursor c_check_if_tax_exists(p_transaction_id in number, p_tax_id in number) is
909: select cdl_system_reference4, attribute9
910: from jai_pa_tax_trxs
911: where cdl_system_reference4 = p_transaction_id
912: and attribute9 = p_tax_id;
913:
914: r_check_if_tax_exists c_check_if_tax_exists%rowtype;

Line 999: -- Check if the Tax lines already exist in JAI_PA_TAX_TRXS

995: nvl(r_po_rcpt.receipt_exchange_rate,1))
996: LOOP
997:
998: -- Added by Jia for FP Bug#9863751, Begin
999: -- Check if the Tax lines already exist in JAI_PA_TAX_TRXS
1000: ------------------------------------------------------------------------------------
1001: open c_check_if_tax_exists (r_po_rcpt.cdl_system_reference4, rec_get_non_rec_taxes.tax_id);
1002: fetch c_check_if_tax_exists into r_check_if_tax_exists;
1003: FND_FILE.put_line(FND_FILE.log, 'r_check_if_tax_exists.tax_exist: ' || r_check_if_tax_exists.cdl_system_reference4 || ':'

Line 1263: -- Insert into jai_pa_tax_trxs before inserting into pa_transaction_interface_all

1259: -- Commented by Jia for FP Bug#9863751, End
1260:
1261:
1262: -- Added by Jia for FP Bug#9863751, Begin
1263: -- Insert into jai_pa_tax_trxs before inserting into pa_transaction_interface_all
1264: -- This is done to prevent duplicate Tax lines from getting interfaced to Projects
1265: ------------------------------------------------------------------------------------
1266: FND_FILE.put_line(FND_FILE.log, 'Inserting into jai_pa_tax_trxs');
1267:

Line 1266: FND_FILE.put_line(FND_FILE.log, 'Inserting into jai_pa_tax_trxs');

1262: -- Added by Jia for FP Bug#9863751, Begin
1263: -- Insert into jai_pa_tax_trxs before inserting into pa_transaction_interface_all
1264: -- This is done to prevent duplicate Tax lines from getting interfaced to Projects
1265: ------------------------------------------------------------------------------------
1266: FND_FILE.put_line(FND_FILE.log, 'Inserting into jai_pa_tax_trxs');
1267:
1268: INSERT INTO jai_pa_tax_trxs(
1269: TRANSACTION_SOURCE ,
1270: BATCH_NAME ,

Line 1268: INSERT INTO jai_pa_tax_trxs(

1264: -- This is done to prevent duplicate Tax lines from getting interfaced to Projects
1265: ------------------------------------------------------------------------------------
1266: FND_FILE.put_line(FND_FILE.log, 'Inserting into jai_pa_tax_trxs');
1267:
1268: INSERT INTO jai_pa_tax_trxs(
1269: TRANSACTION_SOURCE ,
1270: BATCH_NAME ,
1271: EXPENDITURE_ENDING_DATE ,
1272: EMPLOYEE_NUMBER ,

Line 1512: -- Insert records into pa_transaction_interface_all from jai_pa_tax_trxs

1508: END IF;
1509:
1510: END LOOP;
1511:
1512: -- Insert records into pa_transaction_interface_all from jai_pa_tax_trxs
1513: -- Only unprocessed records must be inserted - This is identified by using the PA_ADDITION_FLAG
1514: FOR r_jai_pa_tax_trxs IN c_jai_pa_tax_trxs
1515: LOOP
1516:

Line 1514: FOR r_jai_pa_tax_trxs IN c_jai_pa_tax_trxs

1510: END LOOP;
1511:
1512: -- Insert records into pa_transaction_interface_all from jai_pa_tax_trxs
1513: -- Only unprocessed records must be inserted - This is identified by using the PA_ADDITION_FLAG
1514: FOR r_jai_pa_tax_trxs IN c_jai_pa_tax_trxs
1515: LOOP
1516:
1517: SELECT pa_txn_interface_s.nextval
1518: INTO ln_txn_interface_id

Line 1522: FND_FILE.put_line(FND_FILE.log, 'Debugs Values: ' || R_JAI_PA_TAX_TRXS.TRANSACTION_SOURCE || ':' || R_JAI_PA_TAX_TRXS.BATCH_NAME || ':'

1518: INTO ln_txn_interface_id
1519: FROM dual;
1520:
1521: FND_FILE.put_line(FND_FILE.log, 'Inserting into pa_transaction_interface_all :' || ln_txn_interface_id);
1522: FND_FILE.put_line(FND_FILE.log, 'Debugs Values: ' || R_JAI_PA_TAX_TRXS.TRANSACTION_SOURCE || ':' || R_JAI_PA_TAX_TRXS.BATCH_NAME || ':'
1523: || R_JAI_PA_TAX_TRXS.TRANSACTION_STATUS_CODE ||
1524: ':' || R_JAI_PA_TAX_TRXS.SYSTEM_LINKAGE || ':' || R_JAI_PA_TAX_TRXS.ATTRIBUTE10 || ':' || R_JAI_PA_TAX_TRXS.INTERFACE_ID
1525: || ':' || R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE4 || ':' || R_JAI_PA_TAX_TRXS.ATTRIBUTE9);
1526:

Line 1523: || R_JAI_PA_TAX_TRXS.TRANSACTION_STATUS_CODE ||

1519: FROM dual;
1520:
1521: FND_FILE.put_line(FND_FILE.log, 'Inserting into pa_transaction_interface_all :' || ln_txn_interface_id);
1522: FND_FILE.put_line(FND_FILE.log, 'Debugs Values: ' || R_JAI_PA_TAX_TRXS.TRANSACTION_SOURCE || ':' || R_JAI_PA_TAX_TRXS.BATCH_NAME || ':'
1523: || R_JAI_PA_TAX_TRXS.TRANSACTION_STATUS_CODE ||
1524: ':' || R_JAI_PA_TAX_TRXS.SYSTEM_LINKAGE || ':' || R_JAI_PA_TAX_TRXS.ATTRIBUTE10 || ':' || R_JAI_PA_TAX_TRXS.INTERFACE_ID
1525: || ':' || R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE4 || ':' || R_JAI_PA_TAX_TRXS.ATTRIBUTE9);
1526:
1527: INSERT INTO pa_transaction_interface_all(

Line 1524: ':' || R_JAI_PA_TAX_TRXS.SYSTEM_LINKAGE || ':' || R_JAI_PA_TAX_TRXS.ATTRIBUTE10 || ':' || R_JAI_PA_TAX_TRXS.INTERFACE_ID

1520:
1521: FND_FILE.put_line(FND_FILE.log, 'Inserting into pa_transaction_interface_all :' || ln_txn_interface_id);
1522: FND_FILE.put_line(FND_FILE.log, 'Debugs Values: ' || R_JAI_PA_TAX_TRXS.TRANSACTION_SOURCE || ':' || R_JAI_PA_TAX_TRXS.BATCH_NAME || ':'
1523: || R_JAI_PA_TAX_TRXS.TRANSACTION_STATUS_CODE ||
1524: ':' || R_JAI_PA_TAX_TRXS.SYSTEM_LINKAGE || ':' || R_JAI_PA_TAX_TRXS.ATTRIBUTE10 || ':' || R_JAI_PA_TAX_TRXS.INTERFACE_ID
1525: || ':' || R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE4 || ':' || R_JAI_PA_TAX_TRXS.ATTRIBUTE9);
1526:
1527: INSERT INTO pa_transaction_interface_all(
1528: TRANSACTION_SOURCE ,

Line 1525: || ':' || R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE4 || ':' || R_JAI_PA_TAX_TRXS.ATTRIBUTE9);

1521: FND_FILE.put_line(FND_FILE.log, 'Inserting into pa_transaction_interface_all :' || ln_txn_interface_id);
1522: FND_FILE.put_line(FND_FILE.log, 'Debugs Values: ' || R_JAI_PA_TAX_TRXS.TRANSACTION_SOURCE || ':' || R_JAI_PA_TAX_TRXS.BATCH_NAME || ':'
1523: || R_JAI_PA_TAX_TRXS.TRANSACTION_STATUS_CODE ||
1524: ':' || R_JAI_PA_TAX_TRXS.SYSTEM_LINKAGE || ':' || R_JAI_PA_TAX_TRXS.ATTRIBUTE10 || ':' || R_JAI_PA_TAX_TRXS.INTERFACE_ID
1525: || ':' || R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE4 || ':' || R_JAI_PA_TAX_TRXS.ATTRIBUTE9);
1526:
1527: INSERT INTO pa_transaction_interface_all(
1528: TRANSACTION_SOURCE ,
1529: BATCH_NAME ,

Line 1641: R_JAI_PA_TAX_TRXS.TRANSACTION_SOURCE ,

1637: SC_XFER_CODE ,
1638: ADJUSTED_TXN_INTERFACE_ID ,
1639: NET_ZERO_ADJUSTMENT_FLAG
1640: ) VALUES (
1641: R_JAI_PA_TAX_TRXS.TRANSACTION_SOURCE ,
1642: R_JAI_PA_TAX_TRXS.BATCH_NAME ,
1643: R_JAI_PA_TAX_TRXS.EXPENDITURE_ENDING_DATE ,
1644: R_JAI_PA_TAX_TRXS.EMPLOYEE_NUMBER ,
1645: R_JAI_PA_TAX_TRXS.ORGANIZATION_NAME ,

Line 1642: R_JAI_PA_TAX_TRXS.BATCH_NAME ,

1638: ADJUSTED_TXN_INTERFACE_ID ,
1639: NET_ZERO_ADJUSTMENT_FLAG
1640: ) VALUES (
1641: R_JAI_PA_TAX_TRXS.TRANSACTION_SOURCE ,
1642: R_JAI_PA_TAX_TRXS.BATCH_NAME ,
1643: R_JAI_PA_TAX_TRXS.EXPENDITURE_ENDING_DATE ,
1644: R_JAI_PA_TAX_TRXS.EMPLOYEE_NUMBER ,
1645: R_JAI_PA_TAX_TRXS.ORGANIZATION_NAME ,
1646: R_JAI_PA_TAX_TRXS.EXPENDITURE_ITEM_DATE ,

Line 1643: R_JAI_PA_TAX_TRXS.EXPENDITURE_ENDING_DATE ,

1639: NET_ZERO_ADJUSTMENT_FLAG
1640: ) VALUES (
1641: R_JAI_PA_TAX_TRXS.TRANSACTION_SOURCE ,
1642: R_JAI_PA_TAX_TRXS.BATCH_NAME ,
1643: R_JAI_PA_TAX_TRXS.EXPENDITURE_ENDING_DATE ,
1644: R_JAI_PA_TAX_TRXS.EMPLOYEE_NUMBER ,
1645: R_JAI_PA_TAX_TRXS.ORGANIZATION_NAME ,
1646: R_JAI_PA_TAX_TRXS.EXPENDITURE_ITEM_DATE ,
1647: R_JAI_PA_TAX_TRXS.PROJECT_NUMBER ,

Line 1644: R_JAI_PA_TAX_TRXS.EMPLOYEE_NUMBER ,

1640: ) VALUES (
1641: R_JAI_PA_TAX_TRXS.TRANSACTION_SOURCE ,
1642: R_JAI_PA_TAX_TRXS.BATCH_NAME ,
1643: R_JAI_PA_TAX_TRXS.EXPENDITURE_ENDING_DATE ,
1644: R_JAI_PA_TAX_TRXS.EMPLOYEE_NUMBER ,
1645: R_JAI_PA_TAX_TRXS.ORGANIZATION_NAME ,
1646: R_JAI_PA_TAX_TRXS.EXPENDITURE_ITEM_DATE ,
1647: R_JAI_PA_TAX_TRXS.PROJECT_NUMBER ,
1648: R_JAI_PA_TAX_TRXS.TASK_NUMBER ,

Line 1645: R_JAI_PA_TAX_TRXS.ORGANIZATION_NAME ,

1641: R_JAI_PA_TAX_TRXS.TRANSACTION_SOURCE ,
1642: R_JAI_PA_TAX_TRXS.BATCH_NAME ,
1643: R_JAI_PA_TAX_TRXS.EXPENDITURE_ENDING_DATE ,
1644: R_JAI_PA_TAX_TRXS.EMPLOYEE_NUMBER ,
1645: R_JAI_PA_TAX_TRXS.ORGANIZATION_NAME ,
1646: R_JAI_PA_TAX_TRXS.EXPENDITURE_ITEM_DATE ,
1647: R_JAI_PA_TAX_TRXS.PROJECT_NUMBER ,
1648: R_JAI_PA_TAX_TRXS.TASK_NUMBER ,
1649: R_JAI_PA_TAX_TRXS.EXPENDITURE_TYPE ,

Line 1646: R_JAI_PA_TAX_TRXS.EXPENDITURE_ITEM_DATE ,

1642: R_JAI_PA_TAX_TRXS.BATCH_NAME ,
1643: R_JAI_PA_TAX_TRXS.EXPENDITURE_ENDING_DATE ,
1644: R_JAI_PA_TAX_TRXS.EMPLOYEE_NUMBER ,
1645: R_JAI_PA_TAX_TRXS.ORGANIZATION_NAME ,
1646: R_JAI_PA_TAX_TRXS.EXPENDITURE_ITEM_DATE ,
1647: R_JAI_PA_TAX_TRXS.PROJECT_NUMBER ,
1648: R_JAI_PA_TAX_TRXS.TASK_NUMBER ,
1649: R_JAI_PA_TAX_TRXS.EXPENDITURE_TYPE ,
1650: R_JAI_PA_TAX_TRXS.NON_LABOR_RESOURCE ,

Line 1647: R_JAI_PA_TAX_TRXS.PROJECT_NUMBER ,

1643: R_JAI_PA_TAX_TRXS.EXPENDITURE_ENDING_DATE ,
1644: R_JAI_PA_TAX_TRXS.EMPLOYEE_NUMBER ,
1645: R_JAI_PA_TAX_TRXS.ORGANIZATION_NAME ,
1646: R_JAI_PA_TAX_TRXS.EXPENDITURE_ITEM_DATE ,
1647: R_JAI_PA_TAX_TRXS.PROJECT_NUMBER ,
1648: R_JAI_PA_TAX_TRXS.TASK_NUMBER ,
1649: R_JAI_PA_TAX_TRXS.EXPENDITURE_TYPE ,
1650: R_JAI_PA_TAX_TRXS.NON_LABOR_RESOURCE ,
1651: R_JAI_PA_TAX_TRXS.NON_LABOR_RESOURCE_ORG_NAME ,

Line 1648: R_JAI_PA_TAX_TRXS.TASK_NUMBER ,

1644: R_JAI_PA_TAX_TRXS.EMPLOYEE_NUMBER ,
1645: R_JAI_PA_TAX_TRXS.ORGANIZATION_NAME ,
1646: R_JAI_PA_TAX_TRXS.EXPENDITURE_ITEM_DATE ,
1647: R_JAI_PA_TAX_TRXS.PROJECT_NUMBER ,
1648: R_JAI_PA_TAX_TRXS.TASK_NUMBER ,
1649: R_JAI_PA_TAX_TRXS.EXPENDITURE_TYPE ,
1650: R_JAI_PA_TAX_TRXS.NON_LABOR_RESOURCE ,
1651: R_JAI_PA_TAX_TRXS.NON_LABOR_RESOURCE_ORG_NAME ,
1652: R_JAI_PA_TAX_TRXS.QUANTITY ,

Line 1649: R_JAI_PA_TAX_TRXS.EXPENDITURE_TYPE ,

1645: R_JAI_PA_TAX_TRXS.ORGANIZATION_NAME ,
1646: R_JAI_PA_TAX_TRXS.EXPENDITURE_ITEM_DATE ,
1647: R_JAI_PA_TAX_TRXS.PROJECT_NUMBER ,
1648: R_JAI_PA_TAX_TRXS.TASK_NUMBER ,
1649: R_JAI_PA_TAX_TRXS.EXPENDITURE_TYPE ,
1650: R_JAI_PA_TAX_TRXS.NON_LABOR_RESOURCE ,
1651: R_JAI_PA_TAX_TRXS.NON_LABOR_RESOURCE_ORG_NAME ,
1652: R_JAI_PA_TAX_TRXS.QUANTITY ,
1653: R_JAI_PA_TAX_TRXS.RAW_COST ,

Line 1650: R_JAI_PA_TAX_TRXS.NON_LABOR_RESOURCE ,

1646: R_JAI_PA_TAX_TRXS.EXPENDITURE_ITEM_DATE ,
1647: R_JAI_PA_TAX_TRXS.PROJECT_NUMBER ,
1648: R_JAI_PA_TAX_TRXS.TASK_NUMBER ,
1649: R_JAI_PA_TAX_TRXS.EXPENDITURE_TYPE ,
1650: R_JAI_PA_TAX_TRXS.NON_LABOR_RESOURCE ,
1651: R_JAI_PA_TAX_TRXS.NON_LABOR_RESOURCE_ORG_NAME ,
1652: R_JAI_PA_TAX_TRXS.QUANTITY ,
1653: R_JAI_PA_TAX_TRXS.RAW_COST ,
1654: R_JAI_PA_TAX_TRXS.EXPENDITURE_COMMENT ,

Line 1651: R_JAI_PA_TAX_TRXS.NON_LABOR_RESOURCE_ORG_NAME ,

1647: R_JAI_PA_TAX_TRXS.PROJECT_NUMBER ,
1648: R_JAI_PA_TAX_TRXS.TASK_NUMBER ,
1649: R_JAI_PA_TAX_TRXS.EXPENDITURE_TYPE ,
1650: R_JAI_PA_TAX_TRXS.NON_LABOR_RESOURCE ,
1651: R_JAI_PA_TAX_TRXS.NON_LABOR_RESOURCE_ORG_NAME ,
1652: R_JAI_PA_TAX_TRXS.QUANTITY ,
1653: R_JAI_PA_TAX_TRXS.RAW_COST ,
1654: R_JAI_PA_TAX_TRXS.EXPENDITURE_COMMENT ,
1655: R_JAI_PA_TAX_TRXS.TRANSACTION_STATUS_CODE ,

Line 1652: R_JAI_PA_TAX_TRXS.QUANTITY ,

1648: R_JAI_PA_TAX_TRXS.TASK_NUMBER ,
1649: R_JAI_PA_TAX_TRXS.EXPENDITURE_TYPE ,
1650: R_JAI_PA_TAX_TRXS.NON_LABOR_RESOURCE ,
1651: R_JAI_PA_TAX_TRXS.NON_LABOR_RESOURCE_ORG_NAME ,
1652: R_JAI_PA_TAX_TRXS.QUANTITY ,
1653: R_JAI_PA_TAX_TRXS.RAW_COST ,
1654: R_JAI_PA_TAX_TRXS.EXPENDITURE_COMMENT ,
1655: R_JAI_PA_TAX_TRXS.TRANSACTION_STATUS_CODE ,
1656: R_JAI_PA_TAX_TRXS.TRANSACTION_REJECTION_CODE ,

Line 1653: R_JAI_PA_TAX_TRXS.RAW_COST ,

1649: R_JAI_PA_TAX_TRXS.EXPENDITURE_TYPE ,
1650: R_JAI_PA_TAX_TRXS.NON_LABOR_RESOURCE ,
1651: R_JAI_PA_TAX_TRXS.NON_LABOR_RESOURCE_ORG_NAME ,
1652: R_JAI_PA_TAX_TRXS.QUANTITY ,
1653: R_JAI_PA_TAX_TRXS.RAW_COST ,
1654: R_JAI_PA_TAX_TRXS.EXPENDITURE_COMMENT ,
1655: R_JAI_PA_TAX_TRXS.TRANSACTION_STATUS_CODE ,
1656: R_JAI_PA_TAX_TRXS.TRANSACTION_REJECTION_CODE ,
1657: R_JAI_PA_TAX_TRXS.EXPENDITURE_ID ,

Line 1654: R_JAI_PA_TAX_TRXS.EXPENDITURE_COMMENT ,

1650: R_JAI_PA_TAX_TRXS.NON_LABOR_RESOURCE ,
1651: R_JAI_PA_TAX_TRXS.NON_LABOR_RESOURCE_ORG_NAME ,
1652: R_JAI_PA_TAX_TRXS.QUANTITY ,
1653: R_JAI_PA_TAX_TRXS.RAW_COST ,
1654: R_JAI_PA_TAX_TRXS.EXPENDITURE_COMMENT ,
1655: R_JAI_PA_TAX_TRXS.TRANSACTION_STATUS_CODE ,
1656: R_JAI_PA_TAX_TRXS.TRANSACTION_REJECTION_CODE ,
1657: R_JAI_PA_TAX_TRXS.EXPENDITURE_ID ,
1658: FND_GLOBAL.CONC_REQUEST_ID() , /*FP Bug#9863751 - Current Request ID must be populated in ORIG_TRANSACTION_REFERENCE*/

Line 1655: R_JAI_PA_TAX_TRXS.TRANSACTION_STATUS_CODE ,

1651: R_JAI_PA_TAX_TRXS.NON_LABOR_RESOURCE_ORG_NAME ,
1652: R_JAI_PA_TAX_TRXS.QUANTITY ,
1653: R_JAI_PA_TAX_TRXS.RAW_COST ,
1654: R_JAI_PA_TAX_TRXS.EXPENDITURE_COMMENT ,
1655: R_JAI_PA_TAX_TRXS.TRANSACTION_STATUS_CODE ,
1656: R_JAI_PA_TAX_TRXS.TRANSACTION_REJECTION_CODE ,
1657: R_JAI_PA_TAX_TRXS.EXPENDITURE_ID ,
1658: FND_GLOBAL.CONC_REQUEST_ID() , /*FP Bug#9863751 - Current Request ID must be populated in ORIG_TRANSACTION_REFERENCE*/
1659: R_JAI_PA_TAX_TRXS.ATTRIBUTE_CATEGORY ,

Line 1656: R_JAI_PA_TAX_TRXS.TRANSACTION_REJECTION_CODE ,

1652: R_JAI_PA_TAX_TRXS.QUANTITY ,
1653: R_JAI_PA_TAX_TRXS.RAW_COST ,
1654: R_JAI_PA_TAX_TRXS.EXPENDITURE_COMMENT ,
1655: R_JAI_PA_TAX_TRXS.TRANSACTION_STATUS_CODE ,
1656: R_JAI_PA_TAX_TRXS.TRANSACTION_REJECTION_CODE ,
1657: R_JAI_PA_TAX_TRXS.EXPENDITURE_ID ,
1658: FND_GLOBAL.CONC_REQUEST_ID() , /*FP Bug#9863751 - Current Request ID must be populated in ORIG_TRANSACTION_REFERENCE*/
1659: R_JAI_PA_TAX_TRXS.ATTRIBUTE_CATEGORY ,
1660: R_JAI_PA_TAX_TRXS.ATTRIBUTE1 ,

Line 1657: R_JAI_PA_TAX_TRXS.EXPENDITURE_ID ,

1653: R_JAI_PA_TAX_TRXS.RAW_COST ,
1654: R_JAI_PA_TAX_TRXS.EXPENDITURE_COMMENT ,
1655: R_JAI_PA_TAX_TRXS.TRANSACTION_STATUS_CODE ,
1656: R_JAI_PA_TAX_TRXS.TRANSACTION_REJECTION_CODE ,
1657: R_JAI_PA_TAX_TRXS.EXPENDITURE_ID ,
1658: FND_GLOBAL.CONC_REQUEST_ID() , /*FP Bug#9863751 - Current Request ID must be populated in ORIG_TRANSACTION_REFERENCE*/
1659: R_JAI_PA_TAX_TRXS.ATTRIBUTE_CATEGORY ,
1660: R_JAI_PA_TAX_TRXS.ATTRIBUTE1 ,
1661: R_JAI_PA_TAX_TRXS.ATTRIBUTE2 ,

Line 1659: R_JAI_PA_TAX_TRXS.ATTRIBUTE_CATEGORY ,

1655: R_JAI_PA_TAX_TRXS.TRANSACTION_STATUS_CODE ,
1656: R_JAI_PA_TAX_TRXS.TRANSACTION_REJECTION_CODE ,
1657: R_JAI_PA_TAX_TRXS.EXPENDITURE_ID ,
1658: FND_GLOBAL.CONC_REQUEST_ID() , /*FP Bug#9863751 - Current Request ID must be populated in ORIG_TRANSACTION_REFERENCE*/
1659: R_JAI_PA_TAX_TRXS.ATTRIBUTE_CATEGORY ,
1660: R_JAI_PA_TAX_TRXS.ATTRIBUTE1 ,
1661: R_JAI_PA_TAX_TRXS.ATTRIBUTE2 ,
1662: R_JAI_PA_TAX_TRXS.ATTRIBUTE3 ,
1663: R_JAI_PA_TAX_TRXS.ATTRIBUTE4 ,

Line 1660: R_JAI_PA_TAX_TRXS.ATTRIBUTE1 ,

1656: R_JAI_PA_TAX_TRXS.TRANSACTION_REJECTION_CODE ,
1657: R_JAI_PA_TAX_TRXS.EXPENDITURE_ID ,
1658: FND_GLOBAL.CONC_REQUEST_ID() , /*FP Bug#9863751 - Current Request ID must be populated in ORIG_TRANSACTION_REFERENCE*/
1659: R_JAI_PA_TAX_TRXS.ATTRIBUTE_CATEGORY ,
1660: R_JAI_PA_TAX_TRXS.ATTRIBUTE1 ,
1661: R_JAI_PA_TAX_TRXS.ATTRIBUTE2 ,
1662: R_JAI_PA_TAX_TRXS.ATTRIBUTE3 ,
1663: R_JAI_PA_TAX_TRXS.ATTRIBUTE4 ,
1664: R_JAI_PA_TAX_TRXS.ATTRIBUTE5 ,

Line 1661: R_JAI_PA_TAX_TRXS.ATTRIBUTE2 ,

1657: R_JAI_PA_TAX_TRXS.EXPENDITURE_ID ,
1658: FND_GLOBAL.CONC_REQUEST_ID() , /*FP Bug#9863751 - Current Request ID must be populated in ORIG_TRANSACTION_REFERENCE*/
1659: R_JAI_PA_TAX_TRXS.ATTRIBUTE_CATEGORY ,
1660: R_JAI_PA_TAX_TRXS.ATTRIBUTE1 ,
1661: R_JAI_PA_TAX_TRXS.ATTRIBUTE2 ,
1662: R_JAI_PA_TAX_TRXS.ATTRIBUTE3 ,
1663: R_JAI_PA_TAX_TRXS.ATTRIBUTE4 ,
1664: R_JAI_PA_TAX_TRXS.ATTRIBUTE5 ,
1665: R_JAI_PA_TAX_TRXS.ATTRIBUTE6 ,

Line 1662: R_JAI_PA_TAX_TRXS.ATTRIBUTE3 ,

1658: FND_GLOBAL.CONC_REQUEST_ID() , /*FP Bug#9863751 - Current Request ID must be populated in ORIG_TRANSACTION_REFERENCE*/
1659: R_JAI_PA_TAX_TRXS.ATTRIBUTE_CATEGORY ,
1660: R_JAI_PA_TAX_TRXS.ATTRIBUTE1 ,
1661: R_JAI_PA_TAX_TRXS.ATTRIBUTE2 ,
1662: R_JAI_PA_TAX_TRXS.ATTRIBUTE3 ,
1663: R_JAI_PA_TAX_TRXS.ATTRIBUTE4 ,
1664: R_JAI_PA_TAX_TRXS.ATTRIBUTE5 ,
1665: R_JAI_PA_TAX_TRXS.ATTRIBUTE6 ,
1666: R_JAI_PA_TAX_TRXS.ATTRIBUTE7 ,

Line 1663: R_JAI_PA_TAX_TRXS.ATTRIBUTE4 ,

1659: R_JAI_PA_TAX_TRXS.ATTRIBUTE_CATEGORY ,
1660: R_JAI_PA_TAX_TRXS.ATTRIBUTE1 ,
1661: R_JAI_PA_TAX_TRXS.ATTRIBUTE2 ,
1662: R_JAI_PA_TAX_TRXS.ATTRIBUTE3 ,
1663: R_JAI_PA_TAX_TRXS.ATTRIBUTE4 ,
1664: R_JAI_PA_TAX_TRXS.ATTRIBUTE5 ,
1665: R_JAI_PA_TAX_TRXS.ATTRIBUTE6 ,
1666: R_JAI_PA_TAX_TRXS.ATTRIBUTE7 ,
1667: R_JAI_PA_TAX_TRXS.ATTRIBUTE8 ,

Line 1664: R_JAI_PA_TAX_TRXS.ATTRIBUTE5 ,

1660: R_JAI_PA_TAX_TRXS.ATTRIBUTE1 ,
1661: R_JAI_PA_TAX_TRXS.ATTRIBUTE2 ,
1662: R_JAI_PA_TAX_TRXS.ATTRIBUTE3 ,
1663: R_JAI_PA_TAX_TRXS.ATTRIBUTE4 ,
1664: R_JAI_PA_TAX_TRXS.ATTRIBUTE5 ,
1665: R_JAI_PA_TAX_TRXS.ATTRIBUTE6 ,
1666: R_JAI_PA_TAX_TRXS.ATTRIBUTE7 ,
1667: R_JAI_PA_TAX_TRXS.ATTRIBUTE8 ,
1668: R_JAI_PA_TAX_TRXS.ATTRIBUTE9 ,

Line 1665: R_JAI_PA_TAX_TRXS.ATTRIBUTE6 ,

1661: R_JAI_PA_TAX_TRXS.ATTRIBUTE2 ,
1662: R_JAI_PA_TAX_TRXS.ATTRIBUTE3 ,
1663: R_JAI_PA_TAX_TRXS.ATTRIBUTE4 ,
1664: R_JAI_PA_TAX_TRXS.ATTRIBUTE5 ,
1665: R_JAI_PA_TAX_TRXS.ATTRIBUTE6 ,
1666: R_JAI_PA_TAX_TRXS.ATTRIBUTE7 ,
1667: R_JAI_PA_TAX_TRXS.ATTRIBUTE8 ,
1668: R_JAI_PA_TAX_TRXS.ATTRIBUTE9 ,
1669: R_JAI_PA_TAX_TRXS.ATTRIBUTE10 ,

Line 1666: R_JAI_PA_TAX_TRXS.ATTRIBUTE7 ,

1662: R_JAI_PA_TAX_TRXS.ATTRIBUTE3 ,
1663: R_JAI_PA_TAX_TRXS.ATTRIBUTE4 ,
1664: R_JAI_PA_TAX_TRXS.ATTRIBUTE5 ,
1665: R_JAI_PA_TAX_TRXS.ATTRIBUTE6 ,
1666: R_JAI_PA_TAX_TRXS.ATTRIBUTE7 ,
1667: R_JAI_PA_TAX_TRXS.ATTRIBUTE8 ,
1668: R_JAI_PA_TAX_TRXS.ATTRIBUTE9 ,
1669: R_JAI_PA_TAX_TRXS.ATTRIBUTE10 ,
1670: R_JAI_PA_TAX_TRXS.RAW_COST_RATE ,

Line 1667: R_JAI_PA_TAX_TRXS.ATTRIBUTE8 ,

1663: R_JAI_PA_TAX_TRXS.ATTRIBUTE4 ,
1664: R_JAI_PA_TAX_TRXS.ATTRIBUTE5 ,
1665: R_JAI_PA_TAX_TRXS.ATTRIBUTE6 ,
1666: R_JAI_PA_TAX_TRXS.ATTRIBUTE7 ,
1667: R_JAI_PA_TAX_TRXS.ATTRIBUTE8 ,
1668: R_JAI_PA_TAX_TRXS.ATTRIBUTE9 ,
1669: R_JAI_PA_TAX_TRXS.ATTRIBUTE10 ,
1670: R_JAI_PA_TAX_TRXS.RAW_COST_RATE ,
1671: R_JAI_PA_TAX_TRXS.INTERFACE_ID ,

Line 1668: R_JAI_PA_TAX_TRXS.ATTRIBUTE9 ,

1664: R_JAI_PA_TAX_TRXS.ATTRIBUTE5 ,
1665: R_JAI_PA_TAX_TRXS.ATTRIBUTE6 ,
1666: R_JAI_PA_TAX_TRXS.ATTRIBUTE7 ,
1667: R_JAI_PA_TAX_TRXS.ATTRIBUTE8 ,
1668: R_JAI_PA_TAX_TRXS.ATTRIBUTE9 ,
1669: R_JAI_PA_TAX_TRXS.ATTRIBUTE10 ,
1670: R_JAI_PA_TAX_TRXS.RAW_COST_RATE ,
1671: R_JAI_PA_TAX_TRXS.INTERFACE_ID ,
1672: R_JAI_PA_TAX_TRXS.UNMATCHED_NEGATIVE_TXN_FLAG ,

Line 1669: R_JAI_PA_TAX_TRXS.ATTRIBUTE10 ,

1665: R_JAI_PA_TAX_TRXS.ATTRIBUTE6 ,
1666: R_JAI_PA_TAX_TRXS.ATTRIBUTE7 ,
1667: R_JAI_PA_TAX_TRXS.ATTRIBUTE8 ,
1668: R_JAI_PA_TAX_TRXS.ATTRIBUTE9 ,
1669: R_JAI_PA_TAX_TRXS.ATTRIBUTE10 ,
1670: R_JAI_PA_TAX_TRXS.RAW_COST_RATE ,
1671: R_JAI_PA_TAX_TRXS.INTERFACE_ID ,
1672: R_JAI_PA_TAX_TRXS.UNMATCHED_NEGATIVE_TXN_FLAG ,
1673: R_JAI_PA_TAX_TRXS.EXPENDITURE_ITEM_ID ,

Line 1670: R_JAI_PA_TAX_TRXS.RAW_COST_RATE ,

1666: R_JAI_PA_TAX_TRXS.ATTRIBUTE7 ,
1667: R_JAI_PA_TAX_TRXS.ATTRIBUTE8 ,
1668: R_JAI_PA_TAX_TRXS.ATTRIBUTE9 ,
1669: R_JAI_PA_TAX_TRXS.ATTRIBUTE10 ,
1670: R_JAI_PA_TAX_TRXS.RAW_COST_RATE ,
1671: R_JAI_PA_TAX_TRXS.INTERFACE_ID ,
1672: R_JAI_PA_TAX_TRXS.UNMATCHED_NEGATIVE_TXN_FLAG ,
1673: R_JAI_PA_TAX_TRXS.EXPENDITURE_ITEM_ID ,
1674: R_JAI_PA_TAX_TRXS.ORG_ID ,

Line 1671: R_JAI_PA_TAX_TRXS.INTERFACE_ID ,

1667: R_JAI_PA_TAX_TRXS.ATTRIBUTE8 ,
1668: R_JAI_PA_TAX_TRXS.ATTRIBUTE9 ,
1669: R_JAI_PA_TAX_TRXS.ATTRIBUTE10 ,
1670: R_JAI_PA_TAX_TRXS.RAW_COST_RATE ,
1671: R_JAI_PA_TAX_TRXS.INTERFACE_ID ,
1672: R_JAI_PA_TAX_TRXS.UNMATCHED_NEGATIVE_TXN_FLAG ,
1673: R_JAI_PA_TAX_TRXS.EXPENDITURE_ITEM_ID ,
1674: R_JAI_PA_TAX_TRXS.ORG_ID ,
1675: R_JAI_PA_TAX_TRXS.DR_CODE_COMBINATION_ID ,

Line 1672: R_JAI_PA_TAX_TRXS.UNMATCHED_NEGATIVE_TXN_FLAG ,

1668: R_JAI_PA_TAX_TRXS.ATTRIBUTE9 ,
1669: R_JAI_PA_TAX_TRXS.ATTRIBUTE10 ,
1670: R_JAI_PA_TAX_TRXS.RAW_COST_RATE ,
1671: R_JAI_PA_TAX_TRXS.INTERFACE_ID ,
1672: R_JAI_PA_TAX_TRXS.UNMATCHED_NEGATIVE_TXN_FLAG ,
1673: R_JAI_PA_TAX_TRXS.EXPENDITURE_ITEM_ID ,
1674: R_JAI_PA_TAX_TRXS.ORG_ID ,
1675: R_JAI_PA_TAX_TRXS.DR_CODE_COMBINATION_ID ,
1676: R_JAI_PA_TAX_TRXS.CR_CODE_COMBINATION_ID ,

Line 1673: R_JAI_PA_TAX_TRXS.EXPENDITURE_ITEM_ID ,

1669: R_JAI_PA_TAX_TRXS.ATTRIBUTE10 ,
1670: R_JAI_PA_TAX_TRXS.RAW_COST_RATE ,
1671: R_JAI_PA_TAX_TRXS.INTERFACE_ID ,
1672: R_JAI_PA_TAX_TRXS.UNMATCHED_NEGATIVE_TXN_FLAG ,
1673: R_JAI_PA_TAX_TRXS.EXPENDITURE_ITEM_ID ,
1674: R_JAI_PA_TAX_TRXS.ORG_ID ,
1675: R_JAI_PA_TAX_TRXS.DR_CODE_COMBINATION_ID ,
1676: R_JAI_PA_TAX_TRXS.CR_CODE_COMBINATION_ID ,
1677: R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE1 ,

Line 1674: R_JAI_PA_TAX_TRXS.ORG_ID ,

1670: R_JAI_PA_TAX_TRXS.RAW_COST_RATE ,
1671: R_JAI_PA_TAX_TRXS.INTERFACE_ID ,
1672: R_JAI_PA_TAX_TRXS.UNMATCHED_NEGATIVE_TXN_FLAG ,
1673: R_JAI_PA_TAX_TRXS.EXPENDITURE_ITEM_ID ,
1674: R_JAI_PA_TAX_TRXS.ORG_ID ,
1675: R_JAI_PA_TAX_TRXS.DR_CODE_COMBINATION_ID ,
1676: R_JAI_PA_TAX_TRXS.CR_CODE_COMBINATION_ID ,
1677: R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE1 ,
1678: R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE2 ,

Line 1675: R_JAI_PA_TAX_TRXS.DR_CODE_COMBINATION_ID ,

1671: R_JAI_PA_TAX_TRXS.INTERFACE_ID ,
1672: R_JAI_PA_TAX_TRXS.UNMATCHED_NEGATIVE_TXN_FLAG ,
1673: R_JAI_PA_TAX_TRXS.EXPENDITURE_ITEM_ID ,
1674: R_JAI_PA_TAX_TRXS.ORG_ID ,
1675: R_JAI_PA_TAX_TRXS.DR_CODE_COMBINATION_ID ,
1676: R_JAI_PA_TAX_TRXS.CR_CODE_COMBINATION_ID ,
1677: R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE1 ,
1678: R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE2 ,
1679: R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE3 ,

Line 1676: R_JAI_PA_TAX_TRXS.CR_CODE_COMBINATION_ID ,

1672: R_JAI_PA_TAX_TRXS.UNMATCHED_NEGATIVE_TXN_FLAG ,
1673: R_JAI_PA_TAX_TRXS.EXPENDITURE_ITEM_ID ,
1674: R_JAI_PA_TAX_TRXS.ORG_ID ,
1675: R_JAI_PA_TAX_TRXS.DR_CODE_COMBINATION_ID ,
1676: R_JAI_PA_TAX_TRXS.CR_CODE_COMBINATION_ID ,
1677: R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE1 ,
1678: R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE2 ,
1679: R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE3 ,
1680: R_JAI_PA_TAX_TRXS.GL_DATE ,

Line 1677: R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE1 ,

1673: R_JAI_PA_TAX_TRXS.EXPENDITURE_ITEM_ID ,
1674: R_JAI_PA_TAX_TRXS.ORG_ID ,
1675: R_JAI_PA_TAX_TRXS.DR_CODE_COMBINATION_ID ,
1676: R_JAI_PA_TAX_TRXS.CR_CODE_COMBINATION_ID ,
1677: R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE1 ,
1678: R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE2 ,
1679: R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE3 ,
1680: R_JAI_PA_TAX_TRXS.GL_DATE ,
1681: R_JAI_PA_TAX_TRXS.BURDENED_COST ,

Line 1678: R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE2 ,

1674: R_JAI_PA_TAX_TRXS.ORG_ID ,
1675: R_JAI_PA_TAX_TRXS.DR_CODE_COMBINATION_ID ,
1676: R_JAI_PA_TAX_TRXS.CR_CODE_COMBINATION_ID ,
1677: R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE1 ,
1678: R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE2 ,
1679: R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE3 ,
1680: R_JAI_PA_TAX_TRXS.GL_DATE ,
1681: R_JAI_PA_TAX_TRXS.BURDENED_COST ,
1682: R_JAI_PA_TAX_TRXS.BURDENED_COST_RATE ,

Line 1679: R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE3 ,

1675: R_JAI_PA_TAX_TRXS.DR_CODE_COMBINATION_ID ,
1676: R_JAI_PA_TAX_TRXS.CR_CODE_COMBINATION_ID ,
1677: R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE1 ,
1678: R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE2 ,
1679: R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE3 ,
1680: R_JAI_PA_TAX_TRXS.GL_DATE ,
1681: R_JAI_PA_TAX_TRXS.BURDENED_COST ,
1682: R_JAI_PA_TAX_TRXS.BURDENED_COST_RATE ,
1683: R_JAI_PA_TAX_TRXS.SYSTEM_LINKAGE ,

Line 1680: R_JAI_PA_TAX_TRXS.GL_DATE ,

1676: R_JAI_PA_TAX_TRXS.CR_CODE_COMBINATION_ID ,
1677: R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE1 ,
1678: R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE2 ,
1679: R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE3 ,
1680: R_JAI_PA_TAX_TRXS.GL_DATE ,
1681: R_JAI_PA_TAX_TRXS.BURDENED_COST ,
1682: R_JAI_PA_TAX_TRXS.BURDENED_COST_RATE ,
1683: R_JAI_PA_TAX_TRXS.SYSTEM_LINKAGE ,
1684: ln_txn_interface_id ,

Line 1681: R_JAI_PA_TAX_TRXS.BURDENED_COST ,

1677: R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE1 ,
1678: R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE2 ,
1679: R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE3 ,
1680: R_JAI_PA_TAX_TRXS.GL_DATE ,
1681: R_JAI_PA_TAX_TRXS.BURDENED_COST ,
1682: R_JAI_PA_TAX_TRXS.BURDENED_COST_RATE ,
1683: R_JAI_PA_TAX_TRXS.SYSTEM_LINKAGE ,
1684: ln_txn_interface_id ,
1685: R_JAI_PA_TAX_TRXS.USER_TRANSACTION_SOURCE ,

Line 1682: R_JAI_PA_TAX_TRXS.BURDENED_COST_RATE ,

1678: R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE2 ,
1679: R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE3 ,
1680: R_JAI_PA_TAX_TRXS.GL_DATE ,
1681: R_JAI_PA_TAX_TRXS.BURDENED_COST ,
1682: R_JAI_PA_TAX_TRXS.BURDENED_COST_RATE ,
1683: R_JAI_PA_TAX_TRXS.SYSTEM_LINKAGE ,
1684: ln_txn_interface_id ,
1685: R_JAI_PA_TAX_TRXS.USER_TRANSACTION_SOURCE ,
1686: R_JAI_PA_TAX_TRXS.CREATED_BY ,

Line 1683: R_JAI_PA_TAX_TRXS.SYSTEM_LINKAGE ,

1679: R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE3 ,
1680: R_JAI_PA_TAX_TRXS.GL_DATE ,
1681: R_JAI_PA_TAX_TRXS.BURDENED_COST ,
1682: R_JAI_PA_TAX_TRXS.BURDENED_COST_RATE ,
1683: R_JAI_PA_TAX_TRXS.SYSTEM_LINKAGE ,
1684: ln_txn_interface_id ,
1685: R_JAI_PA_TAX_TRXS.USER_TRANSACTION_SOURCE ,
1686: R_JAI_PA_TAX_TRXS.CREATED_BY ,
1687: R_JAI_PA_TAX_TRXS.CREATION_DATE ,

Line 1685: R_JAI_PA_TAX_TRXS.USER_TRANSACTION_SOURCE ,

1681: R_JAI_PA_TAX_TRXS.BURDENED_COST ,
1682: R_JAI_PA_TAX_TRXS.BURDENED_COST_RATE ,
1683: R_JAI_PA_TAX_TRXS.SYSTEM_LINKAGE ,
1684: ln_txn_interface_id ,
1685: R_JAI_PA_TAX_TRXS.USER_TRANSACTION_SOURCE ,
1686: R_JAI_PA_TAX_TRXS.CREATED_BY ,
1687: R_JAI_PA_TAX_TRXS.CREATION_DATE ,
1688: R_JAI_PA_TAX_TRXS.LAST_UPDATED_BY ,
1689: R_JAI_PA_TAX_TRXS.LAST_UPDATE_DATE ,

Line 1686: R_JAI_PA_TAX_TRXS.CREATED_BY ,

1682: R_JAI_PA_TAX_TRXS.BURDENED_COST_RATE ,
1683: R_JAI_PA_TAX_TRXS.SYSTEM_LINKAGE ,
1684: ln_txn_interface_id ,
1685: R_JAI_PA_TAX_TRXS.USER_TRANSACTION_SOURCE ,
1686: R_JAI_PA_TAX_TRXS.CREATED_BY ,
1687: R_JAI_PA_TAX_TRXS.CREATION_DATE ,
1688: R_JAI_PA_TAX_TRXS.LAST_UPDATED_BY ,
1689: R_JAI_PA_TAX_TRXS.LAST_UPDATE_DATE ,
1690: R_JAI_PA_TAX_TRXS.RECEIPT_CURRENCY_AMOUNT ,

Line 1687: R_JAI_PA_TAX_TRXS.CREATION_DATE ,

1683: R_JAI_PA_TAX_TRXS.SYSTEM_LINKAGE ,
1684: ln_txn_interface_id ,
1685: R_JAI_PA_TAX_TRXS.USER_TRANSACTION_SOURCE ,
1686: R_JAI_PA_TAX_TRXS.CREATED_BY ,
1687: R_JAI_PA_TAX_TRXS.CREATION_DATE ,
1688: R_JAI_PA_TAX_TRXS.LAST_UPDATED_BY ,
1689: R_JAI_PA_TAX_TRXS.LAST_UPDATE_DATE ,
1690: R_JAI_PA_TAX_TRXS.RECEIPT_CURRENCY_AMOUNT ,
1691: R_JAI_PA_TAX_TRXS.RECEIPT_CURRENCY_CODE ,

Line 1688: R_JAI_PA_TAX_TRXS.LAST_UPDATED_BY ,

1684: ln_txn_interface_id ,
1685: R_JAI_PA_TAX_TRXS.USER_TRANSACTION_SOURCE ,
1686: R_JAI_PA_TAX_TRXS.CREATED_BY ,
1687: R_JAI_PA_TAX_TRXS.CREATION_DATE ,
1688: R_JAI_PA_TAX_TRXS.LAST_UPDATED_BY ,
1689: R_JAI_PA_TAX_TRXS.LAST_UPDATE_DATE ,
1690: R_JAI_PA_TAX_TRXS.RECEIPT_CURRENCY_AMOUNT ,
1691: R_JAI_PA_TAX_TRXS.RECEIPT_CURRENCY_CODE ,
1692: R_JAI_PA_TAX_TRXS.RECEIPT_EXCHANGE_RATE ,

Line 1689: R_JAI_PA_TAX_TRXS.LAST_UPDATE_DATE ,

1685: R_JAI_PA_TAX_TRXS.USER_TRANSACTION_SOURCE ,
1686: R_JAI_PA_TAX_TRXS.CREATED_BY ,
1687: R_JAI_PA_TAX_TRXS.CREATION_DATE ,
1688: R_JAI_PA_TAX_TRXS.LAST_UPDATED_BY ,
1689: R_JAI_PA_TAX_TRXS.LAST_UPDATE_DATE ,
1690: R_JAI_PA_TAX_TRXS.RECEIPT_CURRENCY_AMOUNT ,
1691: R_JAI_PA_TAX_TRXS.RECEIPT_CURRENCY_CODE ,
1692: R_JAI_PA_TAX_TRXS.RECEIPT_EXCHANGE_RATE ,
1693: R_JAI_PA_TAX_TRXS.DENOM_CURRENCY_CODE ,

Line 1690: R_JAI_PA_TAX_TRXS.RECEIPT_CURRENCY_AMOUNT ,

1686: R_JAI_PA_TAX_TRXS.CREATED_BY ,
1687: R_JAI_PA_TAX_TRXS.CREATION_DATE ,
1688: R_JAI_PA_TAX_TRXS.LAST_UPDATED_BY ,
1689: R_JAI_PA_TAX_TRXS.LAST_UPDATE_DATE ,
1690: R_JAI_PA_TAX_TRXS.RECEIPT_CURRENCY_AMOUNT ,
1691: R_JAI_PA_TAX_TRXS.RECEIPT_CURRENCY_CODE ,
1692: R_JAI_PA_TAX_TRXS.RECEIPT_EXCHANGE_RATE ,
1693: R_JAI_PA_TAX_TRXS.DENOM_CURRENCY_CODE ,
1694: R_JAI_PA_TAX_TRXS.DENOM_RAW_COST ,

Line 1691: R_JAI_PA_TAX_TRXS.RECEIPT_CURRENCY_CODE ,

1687: R_JAI_PA_TAX_TRXS.CREATION_DATE ,
1688: R_JAI_PA_TAX_TRXS.LAST_UPDATED_BY ,
1689: R_JAI_PA_TAX_TRXS.LAST_UPDATE_DATE ,
1690: R_JAI_PA_TAX_TRXS.RECEIPT_CURRENCY_AMOUNT ,
1691: R_JAI_PA_TAX_TRXS.RECEIPT_CURRENCY_CODE ,
1692: R_JAI_PA_TAX_TRXS.RECEIPT_EXCHANGE_RATE ,
1693: R_JAI_PA_TAX_TRXS.DENOM_CURRENCY_CODE ,
1694: R_JAI_PA_TAX_TRXS.DENOM_RAW_COST ,
1695: R_JAI_PA_TAX_TRXS.DENOM_BURDENED_COST ,

Line 1692: R_JAI_PA_TAX_TRXS.RECEIPT_EXCHANGE_RATE ,

1688: R_JAI_PA_TAX_TRXS.LAST_UPDATED_BY ,
1689: R_JAI_PA_TAX_TRXS.LAST_UPDATE_DATE ,
1690: R_JAI_PA_TAX_TRXS.RECEIPT_CURRENCY_AMOUNT ,
1691: R_JAI_PA_TAX_TRXS.RECEIPT_CURRENCY_CODE ,
1692: R_JAI_PA_TAX_TRXS.RECEIPT_EXCHANGE_RATE ,
1693: R_JAI_PA_TAX_TRXS.DENOM_CURRENCY_CODE ,
1694: R_JAI_PA_TAX_TRXS.DENOM_RAW_COST ,
1695: R_JAI_PA_TAX_TRXS.DENOM_BURDENED_COST ,
1696: R_JAI_PA_TAX_TRXS.ACCT_RATE_DATE ,

Line 1693: R_JAI_PA_TAX_TRXS.DENOM_CURRENCY_CODE ,

1689: R_JAI_PA_TAX_TRXS.LAST_UPDATE_DATE ,
1690: R_JAI_PA_TAX_TRXS.RECEIPT_CURRENCY_AMOUNT ,
1691: R_JAI_PA_TAX_TRXS.RECEIPT_CURRENCY_CODE ,
1692: R_JAI_PA_TAX_TRXS.RECEIPT_EXCHANGE_RATE ,
1693: R_JAI_PA_TAX_TRXS.DENOM_CURRENCY_CODE ,
1694: R_JAI_PA_TAX_TRXS.DENOM_RAW_COST ,
1695: R_JAI_PA_TAX_TRXS.DENOM_BURDENED_COST ,
1696: R_JAI_PA_TAX_TRXS.ACCT_RATE_DATE ,
1697: R_JAI_PA_TAX_TRXS.ACCT_RATE_TYPE ,

Line 1694: R_JAI_PA_TAX_TRXS.DENOM_RAW_COST ,

1690: R_JAI_PA_TAX_TRXS.RECEIPT_CURRENCY_AMOUNT ,
1691: R_JAI_PA_TAX_TRXS.RECEIPT_CURRENCY_CODE ,
1692: R_JAI_PA_TAX_TRXS.RECEIPT_EXCHANGE_RATE ,
1693: R_JAI_PA_TAX_TRXS.DENOM_CURRENCY_CODE ,
1694: R_JAI_PA_TAX_TRXS.DENOM_RAW_COST ,
1695: R_JAI_PA_TAX_TRXS.DENOM_BURDENED_COST ,
1696: R_JAI_PA_TAX_TRXS.ACCT_RATE_DATE ,
1697: R_JAI_PA_TAX_TRXS.ACCT_RATE_TYPE ,
1698: R_JAI_PA_TAX_TRXS.ACCT_EXCHANGE_RATE ,

Line 1695: R_JAI_PA_TAX_TRXS.DENOM_BURDENED_COST ,

1691: R_JAI_PA_TAX_TRXS.RECEIPT_CURRENCY_CODE ,
1692: R_JAI_PA_TAX_TRXS.RECEIPT_EXCHANGE_RATE ,
1693: R_JAI_PA_TAX_TRXS.DENOM_CURRENCY_CODE ,
1694: R_JAI_PA_TAX_TRXS.DENOM_RAW_COST ,
1695: R_JAI_PA_TAX_TRXS.DENOM_BURDENED_COST ,
1696: R_JAI_PA_TAX_TRXS.ACCT_RATE_DATE ,
1697: R_JAI_PA_TAX_TRXS.ACCT_RATE_TYPE ,
1698: R_JAI_PA_TAX_TRXS.ACCT_EXCHANGE_RATE ,
1699: R_JAI_PA_TAX_TRXS.ACCT_RAW_COST ,

Line 1696: R_JAI_PA_TAX_TRXS.ACCT_RATE_DATE ,

1692: R_JAI_PA_TAX_TRXS.RECEIPT_EXCHANGE_RATE ,
1693: R_JAI_PA_TAX_TRXS.DENOM_CURRENCY_CODE ,
1694: R_JAI_PA_TAX_TRXS.DENOM_RAW_COST ,
1695: R_JAI_PA_TAX_TRXS.DENOM_BURDENED_COST ,
1696: R_JAI_PA_TAX_TRXS.ACCT_RATE_DATE ,
1697: R_JAI_PA_TAX_TRXS.ACCT_RATE_TYPE ,
1698: R_JAI_PA_TAX_TRXS.ACCT_EXCHANGE_RATE ,
1699: R_JAI_PA_TAX_TRXS.ACCT_RAW_COST ,
1700: R_JAI_PA_TAX_TRXS.ACCT_BURDENED_COST ,

Line 1697: R_JAI_PA_TAX_TRXS.ACCT_RATE_TYPE ,

1693: R_JAI_PA_TAX_TRXS.DENOM_CURRENCY_CODE ,
1694: R_JAI_PA_TAX_TRXS.DENOM_RAW_COST ,
1695: R_JAI_PA_TAX_TRXS.DENOM_BURDENED_COST ,
1696: R_JAI_PA_TAX_TRXS.ACCT_RATE_DATE ,
1697: R_JAI_PA_TAX_TRXS.ACCT_RATE_TYPE ,
1698: R_JAI_PA_TAX_TRXS.ACCT_EXCHANGE_RATE ,
1699: R_JAI_PA_TAX_TRXS.ACCT_RAW_COST ,
1700: R_JAI_PA_TAX_TRXS.ACCT_BURDENED_COST ,
1701: R_JAI_PA_TAX_TRXS.ACCT_EXCHANGE_ROUNDING_LIMIT ,

Line 1698: R_JAI_PA_TAX_TRXS.ACCT_EXCHANGE_RATE ,

1694: R_JAI_PA_TAX_TRXS.DENOM_RAW_COST ,
1695: R_JAI_PA_TAX_TRXS.DENOM_BURDENED_COST ,
1696: R_JAI_PA_TAX_TRXS.ACCT_RATE_DATE ,
1697: R_JAI_PA_TAX_TRXS.ACCT_RATE_TYPE ,
1698: R_JAI_PA_TAX_TRXS.ACCT_EXCHANGE_RATE ,
1699: R_JAI_PA_TAX_TRXS.ACCT_RAW_COST ,
1700: R_JAI_PA_TAX_TRXS.ACCT_BURDENED_COST ,
1701: R_JAI_PA_TAX_TRXS.ACCT_EXCHANGE_ROUNDING_LIMIT ,
1702: R_JAI_PA_TAX_TRXS.PROJECT_CURRENCY_CODE ,

Line 1699: R_JAI_PA_TAX_TRXS.ACCT_RAW_COST ,

1695: R_JAI_PA_TAX_TRXS.DENOM_BURDENED_COST ,
1696: R_JAI_PA_TAX_TRXS.ACCT_RATE_DATE ,
1697: R_JAI_PA_TAX_TRXS.ACCT_RATE_TYPE ,
1698: R_JAI_PA_TAX_TRXS.ACCT_EXCHANGE_RATE ,
1699: R_JAI_PA_TAX_TRXS.ACCT_RAW_COST ,
1700: R_JAI_PA_TAX_TRXS.ACCT_BURDENED_COST ,
1701: R_JAI_PA_TAX_TRXS.ACCT_EXCHANGE_ROUNDING_LIMIT ,
1702: R_JAI_PA_TAX_TRXS.PROJECT_CURRENCY_CODE ,
1703: R_JAI_PA_TAX_TRXS.PROJECT_RATE_DATE ,

Line 1700: R_JAI_PA_TAX_TRXS.ACCT_BURDENED_COST ,

1696: R_JAI_PA_TAX_TRXS.ACCT_RATE_DATE ,
1697: R_JAI_PA_TAX_TRXS.ACCT_RATE_TYPE ,
1698: R_JAI_PA_TAX_TRXS.ACCT_EXCHANGE_RATE ,
1699: R_JAI_PA_TAX_TRXS.ACCT_RAW_COST ,
1700: R_JAI_PA_TAX_TRXS.ACCT_BURDENED_COST ,
1701: R_JAI_PA_TAX_TRXS.ACCT_EXCHANGE_ROUNDING_LIMIT ,
1702: R_JAI_PA_TAX_TRXS.PROJECT_CURRENCY_CODE ,
1703: R_JAI_PA_TAX_TRXS.PROJECT_RATE_DATE ,
1704: R_JAI_PA_TAX_TRXS.PROJECT_RATE_TYPE ,

Line 1701: R_JAI_PA_TAX_TRXS.ACCT_EXCHANGE_ROUNDING_LIMIT ,

1697: R_JAI_PA_TAX_TRXS.ACCT_RATE_TYPE ,
1698: R_JAI_PA_TAX_TRXS.ACCT_EXCHANGE_RATE ,
1699: R_JAI_PA_TAX_TRXS.ACCT_RAW_COST ,
1700: R_JAI_PA_TAX_TRXS.ACCT_BURDENED_COST ,
1701: R_JAI_PA_TAX_TRXS.ACCT_EXCHANGE_ROUNDING_LIMIT ,
1702: R_JAI_PA_TAX_TRXS.PROJECT_CURRENCY_CODE ,
1703: R_JAI_PA_TAX_TRXS.PROJECT_RATE_DATE ,
1704: R_JAI_PA_TAX_TRXS.PROJECT_RATE_TYPE ,
1705: R_JAI_PA_TAX_TRXS.PROJECT_EXCHANGE_RATE ,

Line 1702: R_JAI_PA_TAX_TRXS.PROJECT_CURRENCY_CODE ,

1698: R_JAI_PA_TAX_TRXS.ACCT_EXCHANGE_RATE ,
1699: R_JAI_PA_TAX_TRXS.ACCT_RAW_COST ,
1700: R_JAI_PA_TAX_TRXS.ACCT_BURDENED_COST ,
1701: R_JAI_PA_TAX_TRXS.ACCT_EXCHANGE_ROUNDING_LIMIT ,
1702: R_JAI_PA_TAX_TRXS.PROJECT_CURRENCY_CODE ,
1703: R_JAI_PA_TAX_TRXS.PROJECT_RATE_DATE ,
1704: R_JAI_PA_TAX_TRXS.PROJECT_RATE_TYPE ,
1705: R_JAI_PA_TAX_TRXS.PROJECT_EXCHANGE_RATE ,
1706: R_JAI_PA_TAX_TRXS.ORIG_EXP_TXN_REFERENCE1 ,

Line 1703: R_JAI_PA_TAX_TRXS.PROJECT_RATE_DATE ,

1699: R_JAI_PA_TAX_TRXS.ACCT_RAW_COST ,
1700: R_JAI_PA_TAX_TRXS.ACCT_BURDENED_COST ,
1701: R_JAI_PA_TAX_TRXS.ACCT_EXCHANGE_ROUNDING_LIMIT ,
1702: R_JAI_PA_TAX_TRXS.PROJECT_CURRENCY_CODE ,
1703: R_JAI_PA_TAX_TRXS.PROJECT_RATE_DATE ,
1704: R_JAI_PA_TAX_TRXS.PROJECT_RATE_TYPE ,
1705: R_JAI_PA_TAX_TRXS.PROJECT_EXCHANGE_RATE ,
1706: R_JAI_PA_TAX_TRXS.ORIG_EXP_TXN_REFERENCE1 ,
1707: R_JAI_PA_TAX_TRXS.ORIG_EXP_TXN_REFERENCE2 ,

Line 1704: R_JAI_PA_TAX_TRXS.PROJECT_RATE_TYPE ,

1700: R_JAI_PA_TAX_TRXS.ACCT_BURDENED_COST ,
1701: R_JAI_PA_TAX_TRXS.ACCT_EXCHANGE_ROUNDING_LIMIT ,
1702: R_JAI_PA_TAX_TRXS.PROJECT_CURRENCY_CODE ,
1703: R_JAI_PA_TAX_TRXS.PROJECT_RATE_DATE ,
1704: R_JAI_PA_TAX_TRXS.PROJECT_RATE_TYPE ,
1705: R_JAI_PA_TAX_TRXS.PROJECT_EXCHANGE_RATE ,
1706: R_JAI_PA_TAX_TRXS.ORIG_EXP_TXN_REFERENCE1 ,
1707: R_JAI_PA_TAX_TRXS.ORIG_EXP_TXN_REFERENCE2 ,
1708: R_JAI_PA_TAX_TRXS.ORIG_EXP_TXN_REFERENCE3 ,

Line 1705: R_JAI_PA_TAX_TRXS.PROJECT_EXCHANGE_RATE ,

1701: R_JAI_PA_TAX_TRXS.ACCT_EXCHANGE_ROUNDING_LIMIT ,
1702: R_JAI_PA_TAX_TRXS.PROJECT_CURRENCY_CODE ,
1703: R_JAI_PA_TAX_TRXS.PROJECT_RATE_DATE ,
1704: R_JAI_PA_TAX_TRXS.PROJECT_RATE_TYPE ,
1705: R_JAI_PA_TAX_TRXS.PROJECT_EXCHANGE_RATE ,
1706: R_JAI_PA_TAX_TRXS.ORIG_EXP_TXN_REFERENCE1 ,
1707: R_JAI_PA_TAX_TRXS.ORIG_EXP_TXN_REFERENCE2 ,
1708: R_JAI_PA_TAX_TRXS.ORIG_EXP_TXN_REFERENCE3 ,
1709: R_JAI_PA_TAX_TRXS.ORIG_USER_EXP_TXN_REFERENCE ,

Line 1706: R_JAI_PA_TAX_TRXS.ORIG_EXP_TXN_REFERENCE1 ,

1702: R_JAI_PA_TAX_TRXS.PROJECT_CURRENCY_CODE ,
1703: R_JAI_PA_TAX_TRXS.PROJECT_RATE_DATE ,
1704: R_JAI_PA_TAX_TRXS.PROJECT_RATE_TYPE ,
1705: R_JAI_PA_TAX_TRXS.PROJECT_EXCHANGE_RATE ,
1706: R_JAI_PA_TAX_TRXS.ORIG_EXP_TXN_REFERENCE1 ,
1707: R_JAI_PA_TAX_TRXS.ORIG_EXP_TXN_REFERENCE2 ,
1708: R_JAI_PA_TAX_TRXS.ORIG_EXP_TXN_REFERENCE3 ,
1709: R_JAI_PA_TAX_TRXS.ORIG_USER_EXP_TXN_REFERENCE ,
1710: R_JAI_PA_TAX_TRXS.VENDOR_NUMBER ,

Line 1707: R_JAI_PA_TAX_TRXS.ORIG_EXP_TXN_REFERENCE2 ,

1703: R_JAI_PA_TAX_TRXS.PROJECT_RATE_DATE ,
1704: R_JAI_PA_TAX_TRXS.PROJECT_RATE_TYPE ,
1705: R_JAI_PA_TAX_TRXS.PROJECT_EXCHANGE_RATE ,
1706: R_JAI_PA_TAX_TRXS.ORIG_EXP_TXN_REFERENCE1 ,
1707: R_JAI_PA_TAX_TRXS.ORIG_EXP_TXN_REFERENCE2 ,
1708: R_JAI_PA_TAX_TRXS.ORIG_EXP_TXN_REFERENCE3 ,
1709: R_JAI_PA_TAX_TRXS.ORIG_USER_EXP_TXN_REFERENCE ,
1710: R_JAI_PA_TAX_TRXS.VENDOR_NUMBER ,
1711: R_JAI_PA_TAX_TRXS.OVERRIDE_TO_ORGANIZATION_NAME,

Line 1708: R_JAI_PA_TAX_TRXS.ORIG_EXP_TXN_REFERENCE3 ,

1704: R_JAI_PA_TAX_TRXS.PROJECT_RATE_TYPE ,
1705: R_JAI_PA_TAX_TRXS.PROJECT_EXCHANGE_RATE ,
1706: R_JAI_PA_TAX_TRXS.ORIG_EXP_TXN_REFERENCE1 ,
1707: R_JAI_PA_TAX_TRXS.ORIG_EXP_TXN_REFERENCE2 ,
1708: R_JAI_PA_TAX_TRXS.ORIG_EXP_TXN_REFERENCE3 ,
1709: R_JAI_PA_TAX_TRXS.ORIG_USER_EXP_TXN_REFERENCE ,
1710: R_JAI_PA_TAX_TRXS.VENDOR_NUMBER ,
1711: R_JAI_PA_TAX_TRXS.OVERRIDE_TO_ORGANIZATION_NAME,
1712: R_JAI_PA_TAX_TRXS.REVERSED_ORIG_TXN_REFERENCE ,

Line 1709: R_JAI_PA_TAX_TRXS.ORIG_USER_EXP_TXN_REFERENCE ,

1705: R_JAI_PA_TAX_TRXS.PROJECT_EXCHANGE_RATE ,
1706: R_JAI_PA_TAX_TRXS.ORIG_EXP_TXN_REFERENCE1 ,
1707: R_JAI_PA_TAX_TRXS.ORIG_EXP_TXN_REFERENCE2 ,
1708: R_JAI_PA_TAX_TRXS.ORIG_EXP_TXN_REFERENCE3 ,
1709: R_JAI_PA_TAX_TRXS.ORIG_USER_EXP_TXN_REFERENCE ,
1710: R_JAI_PA_TAX_TRXS.VENDOR_NUMBER ,
1711: R_JAI_PA_TAX_TRXS.OVERRIDE_TO_ORGANIZATION_NAME,
1712: R_JAI_PA_TAX_TRXS.REVERSED_ORIG_TXN_REFERENCE ,
1713: R_JAI_PA_TAX_TRXS.BILLABLE_FLAG ,

Line 1710: R_JAI_PA_TAX_TRXS.VENDOR_NUMBER ,

1706: R_JAI_PA_TAX_TRXS.ORIG_EXP_TXN_REFERENCE1 ,
1707: R_JAI_PA_TAX_TRXS.ORIG_EXP_TXN_REFERENCE2 ,
1708: R_JAI_PA_TAX_TRXS.ORIG_EXP_TXN_REFERENCE3 ,
1709: R_JAI_PA_TAX_TRXS.ORIG_USER_EXP_TXN_REFERENCE ,
1710: R_JAI_PA_TAX_TRXS.VENDOR_NUMBER ,
1711: R_JAI_PA_TAX_TRXS.OVERRIDE_TO_ORGANIZATION_NAME,
1712: R_JAI_PA_TAX_TRXS.REVERSED_ORIG_TXN_REFERENCE ,
1713: R_JAI_PA_TAX_TRXS.BILLABLE_FLAG ,
1714: R_JAI_PA_TAX_TRXS.PERSON_BUSINESS_GROUP_NAME ,

Line 1711: R_JAI_PA_TAX_TRXS.OVERRIDE_TO_ORGANIZATION_NAME,

1707: R_JAI_PA_TAX_TRXS.ORIG_EXP_TXN_REFERENCE2 ,
1708: R_JAI_PA_TAX_TRXS.ORIG_EXP_TXN_REFERENCE3 ,
1709: R_JAI_PA_TAX_TRXS.ORIG_USER_EXP_TXN_REFERENCE ,
1710: R_JAI_PA_TAX_TRXS.VENDOR_NUMBER ,
1711: R_JAI_PA_TAX_TRXS.OVERRIDE_TO_ORGANIZATION_NAME,
1712: R_JAI_PA_TAX_TRXS.REVERSED_ORIG_TXN_REFERENCE ,
1713: R_JAI_PA_TAX_TRXS.BILLABLE_FLAG ,
1714: R_JAI_PA_TAX_TRXS.PERSON_BUSINESS_GROUP_NAME ,
1715: R_JAI_PA_TAX_TRXS.PROJFUNC_CURRENCY_CODE ,

Line 1712: R_JAI_PA_TAX_TRXS.REVERSED_ORIG_TXN_REFERENCE ,

1708: R_JAI_PA_TAX_TRXS.ORIG_EXP_TXN_REFERENCE3 ,
1709: R_JAI_PA_TAX_TRXS.ORIG_USER_EXP_TXN_REFERENCE ,
1710: R_JAI_PA_TAX_TRXS.VENDOR_NUMBER ,
1711: R_JAI_PA_TAX_TRXS.OVERRIDE_TO_ORGANIZATION_NAME,
1712: R_JAI_PA_TAX_TRXS.REVERSED_ORIG_TXN_REFERENCE ,
1713: R_JAI_PA_TAX_TRXS.BILLABLE_FLAG ,
1714: R_JAI_PA_TAX_TRXS.PERSON_BUSINESS_GROUP_NAME ,
1715: R_JAI_PA_TAX_TRXS.PROJFUNC_CURRENCY_CODE ,
1716: R_JAI_PA_TAX_TRXS.PROJFUNC_COST_RATE_TYPE ,

Line 1713: R_JAI_PA_TAX_TRXS.BILLABLE_FLAG ,

1709: R_JAI_PA_TAX_TRXS.ORIG_USER_EXP_TXN_REFERENCE ,
1710: R_JAI_PA_TAX_TRXS.VENDOR_NUMBER ,
1711: R_JAI_PA_TAX_TRXS.OVERRIDE_TO_ORGANIZATION_NAME,
1712: R_JAI_PA_TAX_TRXS.REVERSED_ORIG_TXN_REFERENCE ,
1713: R_JAI_PA_TAX_TRXS.BILLABLE_FLAG ,
1714: R_JAI_PA_TAX_TRXS.PERSON_BUSINESS_GROUP_NAME ,
1715: R_JAI_PA_TAX_TRXS.PROJFUNC_CURRENCY_CODE ,
1716: R_JAI_PA_TAX_TRXS.PROJFUNC_COST_RATE_TYPE ,
1717: R_JAI_PA_TAX_TRXS.PROJFUNC_COST_RATE_DATE ,

Line 1714: R_JAI_PA_TAX_TRXS.PERSON_BUSINESS_GROUP_NAME ,

1710: R_JAI_PA_TAX_TRXS.VENDOR_NUMBER ,
1711: R_JAI_PA_TAX_TRXS.OVERRIDE_TO_ORGANIZATION_NAME,
1712: R_JAI_PA_TAX_TRXS.REVERSED_ORIG_TXN_REFERENCE ,
1713: R_JAI_PA_TAX_TRXS.BILLABLE_FLAG ,
1714: R_JAI_PA_TAX_TRXS.PERSON_BUSINESS_GROUP_NAME ,
1715: R_JAI_PA_TAX_TRXS.PROJFUNC_CURRENCY_CODE ,
1716: R_JAI_PA_TAX_TRXS.PROJFUNC_COST_RATE_TYPE ,
1717: R_JAI_PA_TAX_TRXS.PROJFUNC_COST_RATE_DATE ,
1718: R_JAI_PA_TAX_TRXS.PROJFUNC_COST_EXCHANGE_RATE ,

Line 1715: R_JAI_PA_TAX_TRXS.PROJFUNC_CURRENCY_CODE ,

1711: R_JAI_PA_TAX_TRXS.OVERRIDE_TO_ORGANIZATION_NAME,
1712: R_JAI_PA_TAX_TRXS.REVERSED_ORIG_TXN_REFERENCE ,
1713: R_JAI_PA_TAX_TRXS.BILLABLE_FLAG ,
1714: R_JAI_PA_TAX_TRXS.PERSON_BUSINESS_GROUP_NAME ,
1715: R_JAI_PA_TAX_TRXS.PROJFUNC_CURRENCY_CODE ,
1716: R_JAI_PA_TAX_TRXS.PROJFUNC_COST_RATE_TYPE ,
1717: R_JAI_PA_TAX_TRXS.PROJFUNC_COST_RATE_DATE ,
1718: R_JAI_PA_TAX_TRXS.PROJFUNC_COST_EXCHANGE_RATE ,
1719: R_JAI_PA_TAX_TRXS.PROJECT_RAW_COST ,

Line 1716: R_JAI_PA_TAX_TRXS.PROJFUNC_COST_RATE_TYPE ,

1712: R_JAI_PA_TAX_TRXS.REVERSED_ORIG_TXN_REFERENCE ,
1713: R_JAI_PA_TAX_TRXS.BILLABLE_FLAG ,
1714: R_JAI_PA_TAX_TRXS.PERSON_BUSINESS_GROUP_NAME ,
1715: R_JAI_PA_TAX_TRXS.PROJFUNC_CURRENCY_CODE ,
1716: R_JAI_PA_TAX_TRXS.PROJFUNC_COST_RATE_TYPE ,
1717: R_JAI_PA_TAX_TRXS.PROJFUNC_COST_RATE_DATE ,
1718: R_JAI_PA_TAX_TRXS.PROJFUNC_COST_EXCHANGE_RATE ,
1719: R_JAI_PA_TAX_TRXS.PROJECT_RAW_COST ,
1720: R_JAI_PA_TAX_TRXS.PROJECT_BURDENED_COST ,

Line 1717: R_JAI_PA_TAX_TRXS.PROJFUNC_COST_RATE_DATE ,

1713: R_JAI_PA_TAX_TRXS.BILLABLE_FLAG ,
1714: R_JAI_PA_TAX_TRXS.PERSON_BUSINESS_GROUP_NAME ,
1715: R_JAI_PA_TAX_TRXS.PROJFUNC_CURRENCY_CODE ,
1716: R_JAI_PA_TAX_TRXS.PROJFUNC_COST_RATE_TYPE ,
1717: R_JAI_PA_TAX_TRXS.PROJFUNC_COST_RATE_DATE ,
1718: R_JAI_PA_TAX_TRXS.PROJFUNC_COST_EXCHANGE_RATE ,
1719: R_JAI_PA_TAX_TRXS.PROJECT_RAW_COST ,
1720: R_JAI_PA_TAX_TRXS.PROJECT_BURDENED_COST ,
1721: R_JAI_PA_TAX_TRXS.ASSIGNMENT_NAME ,

Line 1718: R_JAI_PA_TAX_TRXS.PROJFUNC_COST_EXCHANGE_RATE ,

1714: R_JAI_PA_TAX_TRXS.PERSON_BUSINESS_GROUP_NAME ,
1715: R_JAI_PA_TAX_TRXS.PROJFUNC_CURRENCY_CODE ,
1716: R_JAI_PA_TAX_TRXS.PROJFUNC_COST_RATE_TYPE ,
1717: R_JAI_PA_TAX_TRXS.PROJFUNC_COST_RATE_DATE ,
1718: R_JAI_PA_TAX_TRXS.PROJFUNC_COST_EXCHANGE_RATE ,
1719: R_JAI_PA_TAX_TRXS.PROJECT_RAW_COST ,
1720: R_JAI_PA_TAX_TRXS.PROJECT_BURDENED_COST ,
1721: R_JAI_PA_TAX_TRXS.ASSIGNMENT_NAME ,
1722: R_JAI_PA_TAX_TRXS.WORK_TYPE_NAME ,

Line 1719: R_JAI_PA_TAX_TRXS.PROJECT_RAW_COST ,

1715: R_JAI_PA_TAX_TRXS.PROJFUNC_CURRENCY_CODE ,
1716: R_JAI_PA_TAX_TRXS.PROJFUNC_COST_RATE_TYPE ,
1717: R_JAI_PA_TAX_TRXS.PROJFUNC_COST_RATE_DATE ,
1718: R_JAI_PA_TAX_TRXS.PROJFUNC_COST_EXCHANGE_RATE ,
1719: R_JAI_PA_TAX_TRXS.PROJECT_RAW_COST ,
1720: R_JAI_PA_TAX_TRXS.PROJECT_BURDENED_COST ,
1721: R_JAI_PA_TAX_TRXS.ASSIGNMENT_NAME ,
1722: R_JAI_PA_TAX_TRXS.WORK_TYPE_NAME ,
1723: R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE4 ,

Line 1720: R_JAI_PA_TAX_TRXS.PROJECT_BURDENED_COST ,

1716: R_JAI_PA_TAX_TRXS.PROJFUNC_COST_RATE_TYPE ,
1717: R_JAI_PA_TAX_TRXS.PROJFUNC_COST_RATE_DATE ,
1718: R_JAI_PA_TAX_TRXS.PROJFUNC_COST_EXCHANGE_RATE ,
1719: R_JAI_PA_TAX_TRXS.PROJECT_RAW_COST ,
1720: R_JAI_PA_TAX_TRXS.PROJECT_BURDENED_COST ,
1721: R_JAI_PA_TAX_TRXS.ASSIGNMENT_NAME ,
1722: R_JAI_PA_TAX_TRXS.WORK_TYPE_NAME ,
1723: R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE4 ,
1724: R_JAI_PA_TAX_TRXS.ACCRUAL_FLAG ,

Line 1721: R_JAI_PA_TAX_TRXS.ASSIGNMENT_NAME ,

1717: R_JAI_PA_TAX_TRXS.PROJFUNC_COST_RATE_DATE ,
1718: R_JAI_PA_TAX_TRXS.PROJFUNC_COST_EXCHANGE_RATE ,
1719: R_JAI_PA_TAX_TRXS.PROJECT_RAW_COST ,
1720: R_JAI_PA_TAX_TRXS.PROJECT_BURDENED_COST ,
1721: R_JAI_PA_TAX_TRXS.ASSIGNMENT_NAME ,
1722: R_JAI_PA_TAX_TRXS.WORK_TYPE_NAME ,
1723: R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE4 ,
1724: R_JAI_PA_TAX_TRXS.ACCRUAL_FLAG ,
1725: R_JAI_PA_TAX_TRXS.PROJECT_ID ,

Line 1722: R_JAI_PA_TAX_TRXS.WORK_TYPE_NAME ,

1718: R_JAI_PA_TAX_TRXS.PROJFUNC_COST_EXCHANGE_RATE ,
1719: R_JAI_PA_TAX_TRXS.PROJECT_RAW_COST ,
1720: R_JAI_PA_TAX_TRXS.PROJECT_BURDENED_COST ,
1721: R_JAI_PA_TAX_TRXS.ASSIGNMENT_NAME ,
1722: R_JAI_PA_TAX_TRXS.WORK_TYPE_NAME ,
1723: R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE4 ,
1724: R_JAI_PA_TAX_TRXS.ACCRUAL_FLAG ,
1725: R_JAI_PA_TAX_TRXS.PROJECT_ID ,
1726: R_JAI_PA_TAX_TRXS.TASK_ID ,

Line 1723: R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE4 ,

1719: R_JAI_PA_TAX_TRXS.PROJECT_RAW_COST ,
1720: R_JAI_PA_TAX_TRXS.PROJECT_BURDENED_COST ,
1721: R_JAI_PA_TAX_TRXS.ASSIGNMENT_NAME ,
1722: R_JAI_PA_TAX_TRXS.WORK_TYPE_NAME ,
1723: R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE4 ,
1724: R_JAI_PA_TAX_TRXS.ACCRUAL_FLAG ,
1725: R_JAI_PA_TAX_TRXS.PROJECT_ID ,
1726: R_JAI_PA_TAX_TRXS.TASK_ID ,
1727: R_JAI_PA_TAX_TRXS.PERSON_ID ,

Line 1724: R_JAI_PA_TAX_TRXS.ACCRUAL_FLAG ,

1720: R_JAI_PA_TAX_TRXS.PROJECT_BURDENED_COST ,
1721: R_JAI_PA_TAX_TRXS.ASSIGNMENT_NAME ,
1722: R_JAI_PA_TAX_TRXS.WORK_TYPE_NAME ,
1723: R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE4 ,
1724: R_JAI_PA_TAX_TRXS.ACCRUAL_FLAG ,
1725: R_JAI_PA_TAX_TRXS.PROJECT_ID ,
1726: R_JAI_PA_TAX_TRXS.TASK_ID ,
1727: R_JAI_PA_TAX_TRXS.PERSON_ID ,
1728: R_JAI_PA_TAX_TRXS.ORGANIZATION_ID ,

Line 1725: R_JAI_PA_TAX_TRXS.PROJECT_ID ,

1721: R_JAI_PA_TAX_TRXS.ASSIGNMENT_NAME ,
1722: R_JAI_PA_TAX_TRXS.WORK_TYPE_NAME ,
1723: R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE4 ,
1724: R_JAI_PA_TAX_TRXS.ACCRUAL_FLAG ,
1725: R_JAI_PA_TAX_TRXS.PROJECT_ID ,
1726: R_JAI_PA_TAX_TRXS.TASK_ID ,
1727: R_JAI_PA_TAX_TRXS.PERSON_ID ,
1728: R_JAI_PA_TAX_TRXS.ORGANIZATION_ID ,
1729: R_JAI_PA_TAX_TRXS.NON_LABOR_RESOURCE_ORG_ID ,

Line 1726: R_JAI_PA_TAX_TRXS.TASK_ID ,

1722: R_JAI_PA_TAX_TRXS.WORK_TYPE_NAME ,
1723: R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE4 ,
1724: R_JAI_PA_TAX_TRXS.ACCRUAL_FLAG ,
1725: R_JAI_PA_TAX_TRXS.PROJECT_ID ,
1726: R_JAI_PA_TAX_TRXS.TASK_ID ,
1727: R_JAI_PA_TAX_TRXS.PERSON_ID ,
1728: R_JAI_PA_TAX_TRXS.ORGANIZATION_ID ,
1729: R_JAI_PA_TAX_TRXS.NON_LABOR_RESOURCE_ORG_ID ,
1730: R_JAI_PA_TAX_TRXS.VENDOR_ID ,

Line 1727: R_JAI_PA_TAX_TRXS.PERSON_ID ,

1723: R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE4 ,
1724: R_JAI_PA_TAX_TRXS.ACCRUAL_FLAG ,
1725: R_JAI_PA_TAX_TRXS.PROJECT_ID ,
1726: R_JAI_PA_TAX_TRXS.TASK_ID ,
1727: R_JAI_PA_TAX_TRXS.PERSON_ID ,
1728: R_JAI_PA_TAX_TRXS.ORGANIZATION_ID ,
1729: R_JAI_PA_TAX_TRXS.NON_LABOR_RESOURCE_ORG_ID ,
1730: R_JAI_PA_TAX_TRXS.VENDOR_ID ,
1731: R_JAI_PA_TAX_TRXS.OVERRIDE_TO_ORGANIZATION_ID ,

Line 1728: R_JAI_PA_TAX_TRXS.ORGANIZATION_ID ,

1724: R_JAI_PA_TAX_TRXS.ACCRUAL_FLAG ,
1725: R_JAI_PA_TAX_TRXS.PROJECT_ID ,
1726: R_JAI_PA_TAX_TRXS.TASK_ID ,
1727: R_JAI_PA_TAX_TRXS.PERSON_ID ,
1728: R_JAI_PA_TAX_TRXS.ORGANIZATION_ID ,
1729: R_JAI_PA_TAX_TRXS.NON_LABOR_RESOURCE_ORG_ID ,
1730: R_JAI_PA_TAX_TRXS.VENDOR_ID ,
1731: R_JAI_PA_TAX_TRXS.OVERRIDE_TO_ORGANIZATION_ID ,
1732: R_JAI_PA_TAX_TRXS.ASSIGNMENT_ID ,

Line 1729: R_JAI_PA_TAX_TRXS.NON_LABOR_RESOURCE_ORG_ID ,

1725: R_JAI_PA_TAX_TRXS.PROJECT_ID ,
1726: R_JAI_PA_TAX_TRXS.TASK_ID ,
1727: R_JAI_PA_TAX_TRXS.PERSON_ID ,
1728: R_JAI_PA_TAX_TRXS.ORGANIZATION_ID ,
1729: R_JAI_PA_TAX_TRXS.NON_LABOR_RESOURCE_ORG_ID ,
1730: R_JAI_PA_TAX_TRXS.VENDOR_ID ,
1731: R_JAI_PA_TAX_TRXS.OVERRIDE_TO_ORGANIZATION_ID ,
1732: R_JAI_PA_TAX_TRXS.ASSIGNMENT_ID ,
1733: R_JAI_PA_TAX_TRXS.WORK_TYPE_ID ,

Line 1730: R_JAI_PA_TAX_TRXS.VENDOR_ID ,

1726: R_JAI_PA_TAX_TRXS.TASK_ID ,
1727: R_JAI_PA_TAX_TRXS.PERSON_ID ,
1728: R_JAI_PA_TAX_TRXS.ORGANIZATION_ID ,
1729: R_JAI_PA_TAX_TRXS.NON_LABOR_RESOURCE_ORG_ID ,
1730: R_JAI_PA_TAX_TRXS.VENDOR_ID ,
1731: R_JAI_PA_TAX_TRXS.OVERRIDE_TO_ORGANIZATION_ID ,
1732: R_JAI_PA_TAX_TRXS.ASSIGNMENT_ID ,
1733: R_JAI_PA_TAX_TRXS.WORK_TYPE_ID ,
1734: R_JAI_PA_TAX_TRXS.PERSON_BUSINESS_GROUP_ID ,

Line 1731: R_JAI_PA_TAX_TRXS.OVERRIDE_TO_ORGANIZATION_ID ,

1727: R_JAI_PA_TAX_TRXS.PERSON_ID ,
1728: R_JAI_PA_TAX_TRXS.ORGANIZATION_ID ,
1729: R_JAI_PA_TAX_TRXS.NON_LABOR_RESOURCE_ORG_ID ,
1730: R_JAI_PA_TAX_TRXS.VENDOR_ID ,
1731: R_JAI_PA_TAX_TRXS.OVERRIDE_TO_ORGANIZATION_ID ,
1732: R_JAI_PA_TAX_TRXS.ASSIGNMENT_ID ,
1733: R_JAI_PA_TAX_TRXS.WORK_TYPE_ID ,
1734: R_JAI_PA_TAX_TRXS.PERSON_BUSINESS_GROUP_ID ,
1735: R_JAI_PA_TAX_TRXS.INVENTORY_ITEM_ID ,

Line 1732: R_JAI_PA_TAX_TRXS.ASSIGNMENT_ID ,

1728: R_JAI_PA_TAX_TRXS.ORGANIZATION_ID ,
1729: R_JAI_PA_TAX_TRXS.NON_LABOR_RESOURCE_ORG_ID ,
1730: R_JAI_PA_TAX_TRXS.VENDOR_ID ,
1731: R_JAI_PA_TAX_TRXS.OVERRIDE_TO_ORGANIZATION_ID ,
1732: R_JAI_PA_TAX_TRXS.ASSIGNMENT_ID ,
1733: R_JAI_PA_TAX_TRXS.WORK_TYPE_ID ,
1734: R_JAI_PA_TAX_TRXS.PERSON_BUSINESS_GROUP_ID ,
1735: R_JAI_PA_TAX_TRXS.INVENTORY_ITEM_ID ,
1736: R_JAI_PA_TAX_TRXS.WIP_RESOURCE_ID ,

Line 1733: R_JAI_PA_TAX_TRXS.WORK_TYPE_ID ,

1729: R_JAI_PA_TAX_TRXS.NON_LABOR_RESOURCE_ORG_ID ,
1730: R_JAI_PA_TAX_TRXS.VENDOR_ID ,
1731: R_JAI_PA_TAX_TRXS.OVERRIDE_TO_ORGANIZATION_ID ,
1732: R_JAI_PA_TAX_TRXS.ASSIGNMENT_ID ,
1733: R_JAI_PA_TAX_TRXS.WORK_TYPE_ID ,
1734: R_JAI_PA_TAX_TRXS.PERSON_BUSINESS_GROUP_ID ,
1735: R_JAI_PA_TAX_TRXS.INVENTORY_ITEM_ID ,
1736: R_JAI_PA_TAX_TRXS.WIP_RESOURCE_ID ,
1737: R_JAI_PA_TAX_TRXS.UNIT_OF_MEASURE ,

Line 1734: R_JAI_PA_TAX_TRXS.PERSON_BUSINESS_GROUP_ID ,

1730: R_JAI_PA_TAX_TRXS.VENDOR_ID ,
1731: R_JAI_PA_TAX_TRXS.OVERRIDE_TO_ORGANIZATION_ID ,
1732: R_JAI_PA_TAX_TRXS.ASSIGNMENT_ID ,
1733: R_JAI_PA_TAX_TRXS.WORK_TYPE_ID ,
1734: R_JAI_PA_TAX_TRXS.PERSON_BUSINESS_GROUP_ID ,
1735: R_JAI_PA_TAX_TRXS.INVENTORY_ITEM_ID ,
1736: R_JAI_PA_TAX_TRXS.WIP_RESOURCE_ID ,
1737: R_JAI_PA_TAX_TRXS.UNIT_OF_MEASURE ,
1738: R_JAI_PA_TAX_TRXS.PO_NUMBER ,

Line 1735: R_JAI_PA_TAX_TRXS.INVENTORY_ITEM_ID ,

1731: R_JAI_PA_TAX_TRXS.OVERRIDE_TO_ORGANIZATION_ID ,
1732: R_JAI_PA_TAX_TRXS.ASSIGNMENT_ID ,
1733: R_JAI_PA_TAX_TRXS.WORK_TYPE_ID ,
1734: R_JAI_PA_TAX_TRXS.PERSON_BUSINESS_GROUP_ID ,
1735: R_JAI_PA_TAX_TRXS.INVENTORY_ITEM_ID ,
1736: R_JAI_PA_TAX_TRXS.WIP_RESOURCE_ID ,
1737: R_JAI_PA_TAX_TRXS.UNIT_OF_MEASURE ,
1738: R_JAI_PA_TAX_TRXS.PO_NUMBER ,
1739: R_JAI_PA_TAX_TRXS.PO_HEADER_ID ,

Line 1736: R_JAI_PA_TAX_TRXS.WIP_RESOURCE_ID ,

1732: R_JAI_PA_TAX_TRXS.ASSIGNMENT_ID ,
1733: R_JAI_PA_TAX_TRXS.WORK_TYPE_ID ,
1734: R_JAI_PA_TAX_TRXS.PERSON_BUSINESS_GROUP_ID ,
1735: R_JAI_PA_TAX_TRXS.INVENTORY_ITEM_ID ,
1736: R_JAI_PA_TAX_TRXS.WIP_RESOURCE_ID ,
1737: R_JAI_PA_TAX_TRXS.UNIT_OF_MEASURE ,
1738: R_JAI_PA_TAX_TRXS.PO_NUMBER ,
1739: R_JAI_PA_TAX_TRXS.PO_HEADER_ID ,
1740: R_JAI_PA_TAX_TRXS.PO_LINE_NUM ,

Line 1737: R_JAI_PA_TAX_TRXS.UNIT_OF_MEASURE ,

1733: R_JAI_PA_TAX_TRXS.WORK_TYPE_ID ,
1734: R_JAI_PA_TAX_TRXS.PERSON_BUSINESS_GROUP_ID ,
1735: R_JAI_PA_TAX_TRXS.INVENTORY_ITEM_ID ,
1736: R_JAI_PA_TAX_TRXS.WIP_RESOURCE_ID ,
1737: R_JAI_PA_TAX_TRXS.UNIT_OF_MEASURE ,
1738: R_JAI_PA_TAX_TRXS.PO_NUMBER ,
1739: R_JAI_PA_TAX_TRXS.PO_HEADER_ID ,
1740: R_JAI_PA_TAX_TRXS.PO_LINE_NUM ,
1741: R_JAI_PA_TAX_TRXS.PO_LINE_ID ,

Line 1738: R_JAI_PA_TAX_TRXS.PO_NUMBER ,

1734: R_JAI_PA_TAX_TRXS.PERSON_BUSINESS_GROUP_ID ,
1735: R_JAI_PA_TAX_TRXS.INVENTORY_ITEM_ID ,
1736: R_JAI_PA_TAX_TRXS.WIP_RESOURCE_ID ,
1737: R_JAI_PA_TAX_TRXS.UNIT_OF_MEASURE ,
1738: R_JAI_PA_TAX_TRXS.PO_NUMBER ,
1739: R_JAI_PA_TAX_TRXS.PO_HEADER_ID ,
1740: R_JAI_PA_TAX_TRXS.PO_LINE_NUM ,
1741: R_JAI_PA_TAX_TRXS.PO_LINE_ID ,
1742: R_JAI_PA_TAX_TRXS.PERSON_TYPE ,

Line 1739: R_JAI_PA_TAX_TRXS.PO_HEADER_ID ,

1735: R_JAI_PA_TAX_TRXS.INVENTORY_ITEM_ID ,
1736: R_JAI_PA_TAX_TRXS.WIP_RESOURCE_ID ,
1737: R_JAI_PA_TAX_TRXS.UNIT_OF_MEASURE ,
1738: R_JAI_PA_TAX_TRXS.PO_NUMBER ,
1739: R_JAI_PA_TAX_TRXS.PO_HEADER_ID ,
1740: R_JAI_PA_TAX_TRXS.PO_LINE_NUM ,
1741: R_JAI_PA_TAX_TRXS.PO_LINE_ID ,
1742: R_JAI_PA_TAX_TRXS.PERSON_TYPE ,
1743: R_JAI_PA_TAX_TRXS.PO_PRICE_TYPE ,

Line 1740: R_JAI_PA_TAX_TRXS.PO_LINE_NUM ,

1736: R_JAI_PA_TAX_TRXS.WIP_RESOURCE_ID ,
1737: R_JAI_PA_TAX_TRXS.UNIT_OF_MEASURE ,
1738: R_JAI_PA_TAX_TRXS.PO_NUMBER ,
1739: R_JAI_PA_TAX_TRXS.PO_HEADER_ID ,
1740: R_JAI_PA_TAX_TRXS.PO_LINE_NUM ,
1741: R_JAI_PA_TAX_TRXS.PO_LINE_ID ,
1742: R_JAI_PA_TAX_TRXS.PERSON_TYPE ,
1743: R_JAI_PA_TAX_TRXS.PO_PRICE_TYPE ,
1744: R_JAI_PA_TAX_TRXS.ADJUSTED_EXPENDITURE_ITEM_ID ,

Line 1741: R_JAI_PA_TAX_TRXS.PO_LINE_ID ,

1737: R_JAI_PA_TAX_TRXS.UNIT_OF_MEASURE ,
1738: R_JAI_PA_TAX_TRXS.PO_NUMBER ,
1739: R_JAI_PA_TAX_TRXS.PO_HEADER_ID ,
1740: R_JAI_PA_TAX_TRXS.PO_LINE_NUM ,
1741: R_JAI_PA_TAX_TRXS.PO_LINE_ID ,
1742: R_JAI_PA_TAX_TRXS.PERSON_TYPE ,
1743: R_JAI_PA_TAX_TRXS.PO_PRICE_TYPE ,
1744: R_JAI_PA_TAX_TRXS.ADJUSTED_EXPENDITURE_ITEM_ID ,
1745: R_JAI_PA_TAX_TRXS.FC_DOCUMENT_TYPE ,

Line 1742: R_JAI_PA_TAX_TRXS.PERSON_TYPE ,

1738: R_JAI_PA_TAX_TRXS.PO_NUMBER ,
1739: R_JAI_PA_TAX_TRXS.PO_HEADER_ID ,
1740: R_JAI_PA_TAX_TRXS.PO_LINE_NUM ,
1741: R_JAI_PA_TAX_TRXS.PO_LINE_ID ,
1742: R_JAI_PA_TAX_TRXS.PERSON_TYPE ,
1743: R_JAI_PA_TAX_TRXS.PO_PRICE_TYPE ,
1744: R_JAI_PA_TAX_TRXS.ADJUSTED_EXPENDITURE_ITEM_ID ,
1745: R_JAI_PA_TAX_TRXS.FC_DOCUMENT_TYPE ,
1746: R_JAI_PA_TAX_TRXS.DOCUMENT_TYPE ,

Line 1743: R_JAI_PA_TAX_TRXS.PO_PRICE_TYPE ,

1739: R_JAI_PA_TAX_TRXS.PO_HEADER_ID ,
1740: R_JAI_PA_TAX_TRXS.PO_LINE_NUM ,
1741: R_JAI_PA_TAX_TRXS.PO_LINE_ID ,
1742: R_JAI_PA_TAX_TRXS.PERSON_TYPE ,
1743: R_JAI_PA_TAX_TRXS.PO_PRICE_TYPE ,
1744: R_JAI_PA_TAX_TRXS.ADJUSTED_EXPENDITURE_ITEM_ID ,
1745: R_JAI_PA_TAX_TRXS.FC_DOCUMENT_TYPE ,
1746: R_JAI_PA_TAX_TRXS.DOCUMENT_TYPE ,
1747: R_JAI_PA_TAX_TRXS.DOCUMENT_DISTRIBUTION_TYPE ,

Line 1744: R_JAI_PA_TAX_TRXS.ADJUSTED_EXPENDITURE_ITEM_ID ,

1740: R_JAI_PA_TAX_TRXS.PO_LINE_NUM ,
1741: R_JAI_PA_TAX_TRXS.PO_LINE_ID ,
1742: R_JAI_PA_TAX_TRXS.PERSON_TYPE ,
1743: R_JAI_PA_TAX_TRXS.PO_PRICE_TYPE ,
1744: R_JAI_PA_TAX_TRXS.ADJUSTED_EXPENDITURE_ITEM_ID ,
1745: R_JAI_PA_TAX_TRXS.FC_DOCUMENT_TYPE ,
1746: R_JAI_PA_TAX_TRXS.DOCUMENT_TYPE ,
1747: R_JAI_PA_TAX_TRXS.DOCUMENT_DISTRIBUTION_TYPE ,
1748: R_JAI_PA_TAX_TRXS.SI_ASSETS_ADDITION_FLAG ,

Line 1745: R_JAI_PA_TAX_TRXS.FC_DOCUMENT_TYPE ,

1741: R_JAI_PA_TAX_TRXS.PO_LINE_ID ,
1742: R_JAI_PA_TAX_TRXS.PERSON_TYPE ,
1743: R_JAI_PA_TAX_TRXS.PO_PRICE_TYPE ,
1744: R_JAI_PA_TAX_TRXS.ADJUSTED_EXPENDITURE_ITEM_ID ,
1745: R_JAI_PA_TAX_TRXS.FC_DOCUMENT_TYPE ,
1746: R_JAI_PA_TAX_TRXS.DOCUMENT_TYPE ,
1747: R_JAI_PA_TAX_TRXS.DOCUMENT_DISTRIBUTION_TYPE ,
1748: R_JAI_PA_TAX_TRXS.SI_ASSETS_ADDITION_FLAG ,
1749: R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE5 ,

Line 1746: R_JAI_PA_TAX_TRXS.DOCUMENT_TYPE ,

1742: R_JAI_PA_TAX_TRXS.PERSON_TYPE ,
1743: R_JAI_PA_TAX_TRXS.PO_PRICE_TYPE ,
1744: R_JAI_PA_TAX_TRXS.ADJUSTED_EXPENDITURE_ITEM_ID ,
1745: R_JAI_PA_TAX_TRXS.FC_DOCUMENT_TYPE ,
1746: R_JAI_PA_TAX_TRXS.DOCUMENT_TYPE ,
1747: R_JAI_PA_TAX_TRXS.DOCUMENT_DISTRIBUTION_TYPE ,
1748: R_JAI_PA_TAX_TRXS.SI_ASSETS_ADDITION_FLAG ,
1749: R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE5 ,
1750: R_JAI_PA_TAX_TRXS.SC_XFER_CODE ,

Line 1747: R_JAI_PA_TAX_TRXS.DOCUMENT_DISTRIBUTION_TYPE ,

1743: R_JAI_PA_TAX_TRXS.PO_PRICE_TYPE ,
1744: R_JAI_PA_TAX_TRXS.ADJUSTED_EXPENDITURE_ITEM_ID ,
1745: R_JAI_PA_TAX_TRXS.FC_DOCUMENT_TYPE ,
1746: R_JAI_PA_TAX_TRXS.DOCUMENT_TYPE ,
1747: R_JAI_PA_TAX_TRXS.DOCUMENT_DISTRIBUTION_TYPE ,
1748: R_JAI_PA_TAX_TRXS.SI_ASSETS_ADDITION_FLAG ,
1749: R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE5 ,
1750: R_JAI_PA_TAX_TRXS.SC_XFER_CODE ,
1751: R_JAI_PA_TAX_TRXS.ADJUSTED_TXN_INTERFACE_ID ,

Line 1748: R_JAI_PA_TAX_TRXS.SI_ASSETS_ADDITION_FLAG ,

1744: R_JAI_PA_TAX_TRXS.ADJUSTED_EXPENDITURE_ITEM_ID ,
1745: R_JAI_PA_TAX_TRXS.FC_DOCUMENT_TYPE ,
1746: R_JAI_PA_TAX_TRXS.DOCUMENT_TYPE ,
1747: R_JAI_PA_TAX_TRXS.DOCUMENT_DISTRIBUTION_TYPE ,
1748: R_JAI_PA_TAX_TRXS.SI_ASSETS_ADDITION_FLAG ,
1749: R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE5 ,
1750: R_JAI_PA_TAX_TRXS.SC_XFER_CODE ,
1751: R_JAI_PA_TAX_TRXS.ADJUSTED_TXN_INTERFACE_ID ,
1752: R_JAI_PA_TAX_TRXS.NET_ZERO_ADJUSTMENT_FLAG

Line 1749: R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE5 ,

1745: R_JAI_PA_TAX_TRXS.FC_DOCUMENT_TYPE ,
1746: R_JAI_PA_TAX_TRXS.DOCUMENT_TYPE ,
1747: R_JAI_PA_TAX_TRXS.DOCUMENT_DISTRIBUTION_TYPE ,
1748: R_JAI_PA_TAX_TRXS.SI_ASSETS_ADDITION_FLAG ,
1749: R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE5 ,
1750: R_JAI_PA_TAX_TRXS.SC_XFER_CODE ,
1751: R_JAI_PA_TAX_TRXS.ADJUSTED_TXN_INTERFACE_ID ,
1752: R_JAI_PA_TAX_TRXS.NET_ZERO_ADJUSTMENT_FLAG
1753: );

Line 1750: R_JAI_PA_TAX_TRXS.SC_XFER_CODE ,

1746: R_JAI_PA_TAX_TRXS.DOCUMENT_TYPE ,
1747: R_JAI_PA_TAX_TRXS.DOCUMENT_DISTRIBUTION_TYPE ,
1748: R_JAI_PA_TAX_TRXS.SI_ASSETS_ADDITION_FLAG ,
1749: R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE5 ,
1750: R_JAI_PA_TAX_TRXS.SC_XFER_CODE ,
1751: R_JAI_PA_TAX_TRXS.ADJUSTED_TXN_INTERFACE_ID ,
1752: R_JAI_PA_TAX_TRXS.NET_ZERO_ADJUSTMENT_FLAG
1753: );
1754:

Line 1751: R_JAI_PA_TAX_TRXS.ADJUSTED_TXN_INTERFACE_ID ,

1747: R_JAI_PA_TAX_TRXS.DOCUMENT_DISTRIBUTION_TYPE ,
1748: R_JAI_PA_TAX_TRXS.SI_ASSETS_ADDITION_FLAG ,
1749: R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE5 ,
1750: R_JAI_PA_TAX_TRXS.SC_XFER_CODE ,
1751: R_JAI_PA_TAX_TRXS.ADJUSTED_TXN_INTERFACE_ID ,
1752: R_JAI_PA_TAX_TRXS.NET_ZERO_ADJUSTMENT_FLAG
1753: );
1754:
1755: END LOOP; /*for r_jai_pa_tax_trxs in c_jai_pa_tax_trxs*/

Line 1752: R_JAI_PA_TAX_TRXS.NET_ZERO_ADJUSTMENT_FLAG

1748: R_JAI_PA_TAX_TRXS.SI_ASSETS_ADDITION_FLAG ,
1749: R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE5 ,
1750: R_JAI_PA_TAX_TRXS.SC_XFER_CODE ,
1751: R_JAI_PA_TAX_TRXS.ADJUSTED_TXN_INTERFACE_ID ,
1752: R_JAI_PA_TAX_TRXS.NET_ZERO_ADJUSTMENT_FLAG
1753: );
1754:
1755: END LOOP; /*for r_jai_pa_tax_trxs in c_jai_pa_tax_trxs*/
1756:

Line 1755: END LOOP; /for r_jai_pa_tax_trxs in c_jai_pa_tax_trxs/

1751: R_JAI_PA_TAX_TRXS.ADJUSTED_TXN_INTERFACE_ID ,
1752: R_JAI_PA_TAX_TRXS.NET_ZERO_ADJUSTMENT_FLAG
1753: );
1754:
1755: END LOOP; /*for r_jai_pa_tax_trxs in c_jai_pa_tax_trxs*/
1756:
1757: IF c_jai_pa_tax_trxs%ISOPEN THEN
1758: close c_jai_pa_tax_trxs;
1759: END IF;

Line 1757: IF c_jai_pa_tax_trxs%ISOPEN THEN

1753: );
1754:
1755: END LOOP; /*for r_jai_pa_tax_trxs in c_jai_pa_tax_trxs*/
1756:
1757: IF c_jai_pa_tax_trxs%ISOPEN THEN
1758: close c_jai_pa_tax_trxs;
1759: END IF;
1760: ----------------------------------------------------------------------------------------------------------------
1761: -- Added by Jia for FP Bug#9863751, End

Line 1758: close c_jai_pa_tax_trxs;

1754:
1755: END LOOP; /*for r_jai_pa_tax_trxs in c_jai_pa_tax_trxs*/
1756:
1757: IF c_jai_pa_tax_trxs%ISOPEN THEN
1758: close c_jai_pa_tax_trxs;
1759: END IF;
1760: ----------------------------------------------------------------------------------------------------------------
1761: -- Added by Jia for FP Bug#9863751, End
1762:

Line 1962: SELECT tax_id , -- Added by Jia for FP Bug#9863751, fetched Tax ID to uniquely identify a line in jai_pa_tax_trxs

1958: CURSOR cur_get_tax_amount(cp_transaction_id IN rcv_transactions.transaction_id%TYPE,
1959: cp_curr_conv_rate IN rcv_transactions.CURRENCY_CONVERSION_RATE%Type,
1960: cp_tax_type IN VARCHAR2)
1961: IS
1962: SELECT tax_id , -- Added by Jia for FP Bug#9863751, fetched Tax ID to uniquely identify a line in jai_pa_tax_trxs
1963: nvl(
1964: decode(
1965: nvl(currency,'INR'),'INR',
1966: decode (modvat_flag, 'Y',0,tax_amount),

Line 2011: cursor c_jai_pa_tax_trxs is

2007: WHERE transaction_id = cp_transaction_id;
2008:
2009: -- Added by Jia for FP Bug#9863751, Begin
2010: ---------------------------------------------------------------------------
2011: cursor c_jai_pa_tax_trxs is
2012: select *
2013: from jai_pa_tax_trxs
2014: where pa_addition_flag = 'N'
2015: and expenditure_item_id is NULL;

Line 2013: from jai_pa_tax_trxs

2009: -- Added by Jia for FP Bug#9863751, Begin
2010: ---------------------------------------------------------------------------
2011: cursor c_jai_pa_tax_trxs is
2012: select *
2013: from jai_pa_tax_trxs
2014: where pa_addition_flag = 'N'
2015: and expenditure_item_id is NULL;
2016:
2017: cursor c_check_if_tax_exists(p_transaction_id in number, p_tax_id in number) is

Line 2019: from jai_pa_tax_trxs

2015: and expenditure_item_id is NULL;
2016:
2017: cursor c_check_if_tax_exists(p_transaction_id in number, p_tax_id in number) is
2018: select cdl_system_reference4, attribute9
2019: from jai_pa_tax_trxs
2020: where cdl_system_reference4 = p_transaction_id
2021: and attribute9 = p_tax_id;
2022:
2023: r_check_if_tax_exists c_check_if_tax_exists%rowtype;

Line 2106: -- Check if the Tax lines already exist in JAI_PA_TAX_TRXS

2102: p_tax_type)
2103: LOOP
2104:
2105: -- Added by Jia for FP Bug#9863751, Begin
2106: -- Check if the Tax lines already exist in JAI_PA_TAX_TRXS
2107: ---------------------------------------------------------------------------
2108: open c_check_if_tax_exists (rec_get_deliver_trx.transaction_id, rec_get_tax_amount.tax_id);
2109: fetch c_check_if_tax_exists into r_check_if_tax_exists;
2110: exit when c_check_if_tax_exists%FOUND;

Line 2134: INSERT INTO jai_pa_tax_trxs(

2130: ln_interface_id := ln_unique_id;
2131:
2132: IF nvl(ln_apportioned_trx_tax_amt,0) <> 0 THEN
2133:
2134: INSERT INTO jai_pa_tax_trxs(
2135: transaction_source
2136: , user_transaction_source
2137: , batch_name
2138: , expenditure_ending_date

Line 2214: /*Bug 9231374 - Data would be inserted in jai_pa_tax_trxs immediately after VAT or CENVAT is Unclaimed

2210: ,rec_rcv_receipts.po_header_id
2211: ,rec_rcv_receipts.po_distribution_id
2212: ,rec_rcv_receipts.rcv_transaction_id
2213: ,SYSDATE /*rec_rcv_receipts.GL_Date*/
2214: /*Bug 9231374 - Data would be inserted in jai_pa_tax_trxs immediately after VAT or CENVAT is Unclaimed
2215: Hence SYSDATE can be inserted into GL Date. This would ensure that Unclaimed Taxes are accounted in the correct
2216: periods when they are interfaced to Projects*/
2217: ,ln_org_id
2218: ,'Y'