DBA Data[Home] [Help]

APPS.IEX_PROMISES_PUB dependencies on HZ_PARTIES

Line 1070: l_payer_name HZ_PARTIES.PARTY_NAME%TYPE; --Changed the datatype for bug#5652085 by ehuh 2/28/07

1066:
1067: l_note_payer_id NUMBER;
1068: l_payer_num_id NUMBER;
1069: l_payer_id VARCHAR2(80);
1070: l_payer_name HZ_PARTIES.PARTY_NAME%TYPE; --Changed the datatype for bug#5652085 by ehuh 2/28/07
1071: l_note_payer_type VARCHAR2(100);
1072: l_context_tab IEX_NOTES_PVT.CONTEXTS_TBL_TYPE;
1073: l_note_id NUMBER;
1074: l_org_id number; --Added for bug 7237026 barathsr 17-Nov-2008

Line 1694: l_payer_name HZ_PARTIES.PARTY_NAME%TYPE; --Changed the datatype for bug#5652085 by ehuh 2/28/07

1690:
1691: l_note_payer_id NUMBER;
1692: l_payer_num_id NUMBER;
1693: l_payer_id VARCHAR2(80);
1694: l_payer_name HZ_PARTIES.PARTY_NAME%TYPE; --Changed the datatype for bug#5652085 by ehuh 2/28/07
1695: l_note_payer_type VARCHAR2(100);
1696: l_context_tab IEX_NOTES_PVT.CONTEXTS_TBL_TYPE;
1697: l_note_id NUMBER;
1698: l_cust_id number;

Line 2001: l_payer_name HZ_PARTIES.PARTY_NAME%TYPE; --Changed the datatype for bug#5652085 by ehuh 2/28/07

1997: l_promise_status varchar2(30); -- := 'CANCELLED';
1998: l_note_payer_id NUMBER;
1999: l_payer_num_id NUMBER;
2000: l_payer_id VARCHAR2(80);
2001: l_payer_name HZ_PARTIES.PARTY_NAME%TYPE; --Changed the datatype for bug#5652085 by ehuh 2/28/07
2002: l_note_payer_type VARCHAR2(100);
2003: l_context_tab IEX_NOTES_PVT.CONTEXTS_TBL_TYPE;
2004: l_note_id NUMBER;
2005: l_cust_id number;

Line 2379: l_payer_name HZ_PARTIES.PARTY_NAME%TYPE; --Changed the datatype for bug#5652085 by ehuh 2/28/07

2375: l_broken_on_date date;
2376: l_note_payer_id NUMBER;
2377: l_payer_num_id NUMBER;
2378: l_payer_id VARCHAR2(80);
2379: l_payer_name HZ_PARTIES.PARTY_NAME%TYPE; --Changed the datatype for bug#5652085 by ehuh 2/28/07
2380: l_note_payer_type VARCHAR2(100);
2381: l_context_tab IEX_NOTES_PVT.CONTEXTS_TBL_TYPE;
2382: l_note_id NUMBER;
2383: l_SQL VARCHAR2(1000);