APPS.XTR_IG_TRANSFERS_PKG dependencies on XTR_IG_JOURNAL_STRUCTURES

Line 358: from xtr_ig_journal_structures

354: party_code IN VARCHAR2,
355: currency IN VARCHAR2,
356: party_acct_no IN VARCHAR2) is
357: select 'Y'
358: from xtr_ig_journal_structures
359: where company_code = comp_code
360: and cparty_code = party_code
361: and cp_currency = currency
362: and cp_acct_no = party_acct_no;

Line 383: select xtr_ig_journal_structures_s.nextval into l_jrnl_struc_id from dual;

379: close ig_jrnl;
380:
381: if l_jrnl is null then
382:
383: select xtr_ig_journal_structures_s.nextval into l_jrnl_struc_id from dual;
384:
385: open party_dtls(p_party_code,p_party_acct);
386: fetch party_dtls into l_currency;
387: close party_dtls;

Line 389: insert into xtr_ig_journal_structures( xtr_ig_journal_structure_id,company_code,cparty_code,

385: open party_dtls(p_party_code,p_party_acct);
386: fetch party_dtls into l_currency;
387: close party_dtls;
388:
389: insert into xtr_ig_journal_structures( xtr_ig_journal_structure_id,company_code,cparty_code,
390: cp_currency,cp_acct_no,created_by,creation_Date,last_updated_by,
391: last_update_date,last_update_login)
392: values (l_jrnl_struc_id,p_company_code,p_party_code,
393: l_currency,p_party_acct,FND_GLOBAL.USER_ID,SYSDATE,FND_GLOBAL.USER_ID,