APPS.JAI_AP_DTC_GENERATION_PKG dependencies on JAI_DTC_ROUNDING_SETUPS

Line 1345: from JAI_DTC_ROUNDING_SETUPS

1341: 100,-2,
1342: 1000,-3,0) taxable_basis
1343: ------------------------------------------
1344: --Update by Zhiwei Hou on 20120106 end
1345: from JAI_DTC_ROUNDING_SETUPS
1346: where legal_entity_id in(
1347: select
1348: default_legal_context_id
1349: from hr_operating_units

Line 1376: from JAI_DTC_ROUNDING_SETUPS

1372: 1,0,
1373: 10,-1,
1374: 100,-2,
1375: 1000,-3,NULL) taxable_basis
1376: from JAI_DTC_ROUNDING_SETUPS
1377: where legal_entity_id in(
1378: select
1379: default_legal_context_id
1380: from hr_operating_units

Line 1397: and (JAI_DTC_ROUNDING_SETUPS.from_date > aida.accounting_date

1393: and not exists(
1394: select 1
1395: from ap_invoice_distributions_all aida
1396: where aida.invoice_id = pn_invoice_id
1397: and (JAI_DTC_ROUNDING_SETUPS.from_date > aida.accounting_date
1398: or NVL(JAI_DTC_ROUNDING_SETUPS.to_date, TO_DATE('01019999','DDMMYYYY')) < aida.accounting_date
1399: )
1400: );
1401: ln_rounding_factor number;

Line 1398: or NVL(JAI_DTC_ROUNDING_SETUPS.to_date, TO_DATE('01019999','DDMMYYYY')) < aida.accounting_date

1394: select 1
1395: from ap_invoice_distributions_all aida
1396: where aida.invoice_id = pn_invoice_id
1397: and (JAI_DTC_ROUNDING_SETUPS.from_date > aida.accounting_date
1398: or NVL(JAI_DTC_ROUNDING_SETUPS.to_date, TO_DATE('01019999','DDMMYYYY')) < aida.accounting_date
1399: )
1400: );
1401: ln_rounding_factor number;
1402: BEGIN

Line 1429: from JAI_DTC_ROUNDING_SETUPS

1425: 10,-1,
1426: 100,-2,
1427: 1000,-3,0) tax_basis
1428:
1429: from JAI_DTC_ROUNDING_SETUPS
1430: where legal_entity_id in(
1431: select
1432: default_legal_context_id
1433: from hr_operating_units

Line 1461: from JAI_DTC_ROUNDING_SETUPS

1457: 1,0,
1458: 10,-1,
1459: 100,-2,
1460: 1000,-3,0) tax_basis
1461: from JAI_DTC_ROUNDING_SETUPS
1462: where legal_entity_id in(
1463: select
1464: default_legal_context_id
1465: from hr_operating_units

Line 1482: and (JAI_DTC_ROUNDING_SETUPS.from_date > aida.accounting_date

1478: and not exists(
1479: select 1
1480: from ap_invoice_distributions_all aida
1481: where aida.invoice_id = pn_invoice_id
1482: and (JAI_DTC_ROUNDING_SETUPS.from_date > aida.accounting_date
1483: or NVL(JAI_DTC_ROUNDING_SETUPS.to_date, TO_DATE('01019999','DDMMYYYY')) < aida.accounting_date
1484: )
1485: );
1486: ln_rounding_factor number;

Line 1483: or NVL(JAI_DTC_ROUNDING_SETUPS.to_date, TO_DATE('01019999','DDMMYYYY')) < aida.accounting_date

1479: select 1
1480: from ap_invoice_distributions_all aida
1481: where aida.invoice_id = pn_invoice_id
1482: and (JAI_DTC_ROUNDING_SETUPS.from_date > aida.accounting_date
1483: or NVL(JAI_DTC_ROUNDING_SETUPS.to_date, TO_DATE('01019999','DDMMYYYY')) < aida.accounting_date
1484: )
1485: );
1486: ln_rounding_factor number;
1487: BEGIN