DBA Data[Home] [Help]

APPS.CST_SLA_UPDATE_PKG dependencies on RCV_TRANSACTIONS

Line 1579: l_table_name varchar2(30) := 'RCV_TRANSACTIONS';

1575: IS
1576:
1577: l_worker_id number;
1578: l_product varchar2(30);
1579: l_table_name varchar2(30) := 'RCV_TRANSACTIONS';
1580: l_id_column varchar2(30) := 'TRANSACTION_ID';
1581:
1582:
1583: l_update_name varchar2(30);

Line 1929: from rcv_transactions rt

1925: and mmt1.transaction_source_type_id = 1
1926: and mmt1.logical_trx_type_code = 2
1927: and exists (
1928: select 1
1929: from rcv_transactions rt
1930: where rt.transaction_id = mmt1.rcv_transaction_id
1931: and rt.organization_id = mta.organization_id))))));
1932:
1933: l_rows_processed := SQL%ROWCOUNT;

Line 3269: from rcv_transactions rt,

3265: xla_ae_headers_s.NEXTVAL,
3266: null,
3267: nvl(rae.org_id,
3268: DECODE(l_multi_org_flag,'Y',TO_NUMBER(HOI2.ORG_INFORMATION3),TO_NUMBER(NULL)))
3269: from rcv_transactions rt,
3270: rcv_accounting_events rae,
3271: hr_organization_information hoi2,
3272: gl_ledgers sob,
3273: (select /*+ no_merge leading(rrs) use_hash(xud) swap_join_inputs(xud) */

Line 3645: FROM RCV_TRANSACTIONS rt1

3641: or
3642: (cem.transaction_type_id = 3
3643: and cxs.source_id_int_5 is not null
3644: and cem.attribute = (SELECT TRANSACTION_TYPE
3645: FROM RCV_TRANSACTIONS rt1
3646: WHERE rt1.transaction_id = cxs.source_id_int_5))
3647: )
3648: and gcc.CODE_COMBINATION_ID=rrs.CODE_COMBINATION_ID;
3649: