APPS.RCV_ACCRUALUTILITIES_GRP dependencies on FND_DATE

Line 1085: and fnd_date.date_to_canonical(rt.transaction_date)

1081: from mtl_material_transactions mmt,
1082: mtl_transaction_accounts mta,
1083: rcv_transactions rt
1084: where rt.po_distribution_id = p_po_distribution_id
1085: and fnd_date.date_to_canonical(rt.transaction_date)
1086: between nvl(p_start_txn_date,fnd_date.date_to_canonical(rt.transaction_date))
1087: and nvl(p_end_txn_date,fnd_date.date_to_canonical(sysdate))
1088: and mmt.rcv_transaction_id = rt.transaction_id
1089: and mta.transaction_id = mmt.transaction_id

Line 1086: between nvl(p_start_txn_date,fnd_date.date_to_canonical(rt.transaction_date))

1082: mtl_transaction_accounts mta,
1083: rcv_transactions rt
1084: where rt.po_distribution_id = p_po_distribution_id
1085: and fnd_date.date_to_canonical(rt.transaction_date)
1086: between nvl(p_start_txn_date,fnd_date.date_to_canonical(rt.transaction_date))
1087: and nvl(p_end_txn_date,fnd_date.date_to_canonical(sysdate))
1088: and mmt.rcv_transaction_id = rt.transaction_id
1089: and mta.transaction_id = mmt.transaction_id
1090: and mta.accounting_line_type = 15

Line 1087: and nvl(p_end_txn_date,fnd_date.date_to_canonical(sysdate))

1083: rcv_transactions rt
1084: where rt.po_distribution_id = p_po_distribution_id
1085: and fnd_date.date_to_canonical(rt.transaction_date)
1086: between nvl(p_start_txn_date,fnd_date.date_to_canonical(rt.transaction_date))
1087: and nvl(p_end_txn_date,fnd_date.date_to_canonical(sysdate))
1088: and mmt.rcv_transaction_id = rt.transaction_id
1089: and mta.transaction_id = mmt.transaction_id
1090: and mta.accounting_line_type = 15
1091: and mta.gl_batch_id <> -1;

Line 1100: and fnd_date.date_to_canonical(rt.transaction_date)

1096: into l_encReversalAmt
1097: from rcv_receiving_sub_ledger rrs,
1098: rcv_transactions rt
1099: where rt.po_distribution_id = p_po_distribution_id
1100: and fnd_date.date_to_canonical(rt.transaction_date)
1101: between nvl(p_start_txn_date,fnd_date.date_to_canonical(rt.transaction_date))
1102: and nvl(p_end_txn_date,fnd_date.date_to_canonical(sysdate))
1103: and rrs.rcv_transaction_id = rt.transaction_id
1104: and rrs.actual_flag = 'E';

Line 1101: between nvl(p_start_txn_date,fnd_date.date_to_canonical(rt.transaction_date))

1097: from rcv_receiving_sub_ledger rrs,
1098: rcv_transactions rt
1099: where rt.po_distribution_id = p_po_distribution_id
1100: and fnd_date.date_to_canonical(rt.transaction_date)
1101: between nvl(p_start_txn_date,fnd_date.date_to_canonical(rt.transaction_date))
1102: and nvl(p_end_txn_date,fnd_date.date_to_canonical(sysdate))
1103: and rrs.rcv_transaction_id = rt.transaction_id
1104: and rrs.actual_flag = 'E';
1105: else

Line 1102: and nvl(p_end_txn_date,fnd_date.date_to_canonical(sysdate))

1098: rcv_transactions rt
1099: where rt.po_distribution_id = p_po_distribution_id
1100: and fnd_date.date_to_canonical(rt.transaction_date)
1101: between nvl(p_start_txn_date,fnd_date.date_to_canonical(rt.transaction_date))
1102: and nvl(p_end_txn_date,fnd_date.date_to_canonical(sysdate))
1103: and rrs.rcv_transaction_id = rt.transaction_id
1104: and rrs.actual_flag = 'E';
1105: else
1106: l_stmt_num := 60;