APPS.XTR_MISC_P dependencies on XTR_PARTIES_V

Line 374: from XTR_PARTIES_V a,

370: -- (used in Forms PRO1011 - Confirmations and PRO1012 - Dual Validation).
371: --
372: cursor CHK_CONFO_REQD(l_party_code varchar2) is
373: select 1
374: from XTR_PARTIES_V a,
375: XTR_CONFIRMATION_ACTIONS b
376: where a.party_code= l_party_code
377: and a.confo_group_code = b. confo_action_group
378: and b.action_type = p_action_type

Line 1219: XTR_PARTIES_V b

1215: --
1216: cursor GET_OLD_ACCT_BALS is
1217: select a.ACCOUNT_NUMBER,a.OPENING_BALANCE,a.STATEMENT_DATE,a.CURRENCY,a.PARTY_CODE
1218: from XTR_BANK_ACCOUNTS a,
1219: XTR_PARTIES_V b
1220: where nvl(a.PROJECTED_BALANCE_UPDATED_ON,to_date('01/01/1980','DD/MM/YYYY')) < trunc(SYSDATE)
1221: and nvl(a.SETOFF_ACCOUNT_YN,'N') <> 'Y'
1222: and b.PARTY_CODE = a.PARTY_CODE
1223: and (b.PARTY_TYPE = 'C' or b.INTERNAL_PTY = 'Y');