APPS.XTR_REPLICATE_BANK_BALANCES dependencies on XTR_PARTY_INFO

Line 664: l_cross_ref xtr_party_info.cross_ref_to_other_party%TYPE;

660: x_return_status IN OUT NOCOPY VARCHAR2
661: )
662: IS
663:
664: l_cross_ref xtr_party_info.cross_ref_to_other_party%TYPE;
665: l_exists VARCHAR2(1);
666: l_ce_bank_acct_bal_id xtr_bank_balances.ce_bank_account_balance_id%TYPE;
667: l_ccy xtr_bank_accounts.currency%TYPE;
668:

Line 1395: l_cross_ref xtr_party_info.cross_ref_to_other_party%TYPE;

1391:
1392: l_ccy xtr_bank_accounts.currency%TYPE;
1393: l_portfolio_code xtr_bank_accounts.portfolio_code%TYPE;
1394: l_bank_code xtr_bank_accounts.bank_code%TYPE;
1395: l_cross_ref xtr_party_info.cross_ref_to_other_party%TYPE;
1396: l_bal_exists VARCHAR2(10);
1397: l_dummy_num VARCHAR2(1);
1398: l_bal_date xtr_bank_balances.balance_date%TYPE;
1399: l_accum_int_cfwd xtr_bank_balances.accum_int_cfwd%TYPE;

Line 2260: (SELECT party_code FROM xtr_party_info WHERE ce_bank_branch_id =

2256: AND a.company_code = p_company_code
2257: AND a.limit_type= b.limit_type
2258: AND c.param_name='DISPLAY_LIMIT_WARNING' and c.param_value='Y'
2259: AND a.cparty_code IN
2260: (SELECT party_code FROM xtr_party_info WHERE ce_bank_branch_id =
2261: p_branch_id
2262: );
2263:
2264: if (-(p_bal + p_ledger_balance))>0 then