1911: AND accounting_date <= p_end_date
1912: -- AND accounting_batch_id = p_accounting_batch_id -- excluded so as in the next run records failed to transfer to PSFT will pick again
1913: AND ledger_id IN (
1914: SELECT DISTINCT target_ledger_id
1915: FROM gl_ledger_relationships
1916: WHERE source_ledger_id = l_ledger_id
1917: AND NVL (relationship_enabled_flag, 'N') =
1918: 'Y');
1919:
2088: AND accounting_date <= p_end_date
2089: -- AND accounting_batch_id = p_accounting_batch_id -- excluded so as in the next run records failed to transfer to PSFT will pick again
2090: AND ledger_id IN (
2091: SELECT DISTINCT target_ledger_id
2092: FROM gl_ledger_relationships
2093: WHERE source_ledger_id = l_ledger_id
2094: AND NVL (relationship_enabled_flag, 'N') = 'Y');
2095:
2096: -- Updating the records with group id