APPS.XTR_ACCRUAL_PROCESS_P dependencies on XTR_INTERGROUP_TRANSFERS

Line 3381: from XTR_INTERGROUP_TRANSFERS i

3377: i.DEAL_NUMBER,
3378: decode(i.DAY_COUNT_TYPE,'F','PRIOR','L','FOLLOWING','B') day_count_type, -- AW Japan Project
3379: nvl(i.ROUNDING_TYPE,'R') rounding_type, -- AW Japan Project
3380: decode(nvl(i.DAY_COUNT_TYPE,'L'),'F',1,0) forward_adjust -- AW Japan Project
3381: from XTR_INTERGROUP_TRANSFERS i
3382: where i.COMPANY_CODE = p_company
3383: and i.TRANSACTION_NUMBER =
3384: (select max(k.TRANSACTION_NUMBER)
3385: from XTR_INTERGROUP_TRANSFERS k

Line 3385: from XTR_INTERGROUP_TRANSFERS k

3381: from XTR_INTERGROUP_TRANSFERS i
3382: where i.COMPANY_CODE = p_company
3383: and i.TRANSACTION_NUMBER =
3384: (select max(k.TRANSACTION_NUMBER)
3385: from XTR_INTERGROUP_TRANSFERS k
3386: where k.COMPANY_CODE = i.COMPANY_CODE
3387: and k.PARTY_CODE = i.PARTY_CODE
3388: and k.CURRENCY = i.CURRENCY
3389: and k.TRANSFER_DATE =

Line 3391: from XTR_INTERGROUP_TRANSFERS j

3387: and k.PARTY_CODE = i.PARTY_CODE
3388: and k.CURRENCY = i.CURRENCY
3389: and k.TRANSFER_DATE =
3390: (select max(j.TRANSFER_DATE)
3391: from XTR_INTERGROUP_TRANSFERS j
3392: where j.TRANSFER_DATE <= p_end_date
3393: and j.COMPANY_CODE = i.COMPANY_CODE
3394: and j.PARTY_CODE = i.PARTY_CODE
3395: and j.CURRENCY = i.CURRENCY))

Line 3448: from XTR_INTERGROUP_TRANSFERS

3444: -- Oldest IG Transaction
3445: ------------------------------------
3446: cursor IG_OLDEST (v_deal_no NUMBER) is
3447: select TRANSFER_DATE
3448: from XTR_INTERGROUP_TRANSFERS
3449: where DEAL_NUMBER = v_deal_no
3450: order by TRANSFER_DATE;
3451:
3452: ------------------------------------