DBA Data[Home] [Help]

APPS.IEX_PROMISES_PUB dependencies on HZ_PARTIES

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

1081:
1082: l_note_payer_id NUMBER;
1083: l_payer_num_id NUMBER;
1084: l_payer_id VARCHAR2(80);
1085: l_payer_name HZ_PARTIES.PARTY_NAME%TYPE; --Changed the datatype for bug#5652085 by ehuh 2/28/07
1086: l_note_payer_type VARCHAR2(100);
1087: l_context_tab IEX_NOTES_PVT.CONTEXTS_TBL_TYPE;
1088: l_note_id NUMBER;
1089: l_org_id number; --Added for bug 7237026 barathsr 17-Nov-2008

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

1729:
1730: l_note_payer_id NUMBER;
1731: l_payer_num_id NUMBER;
1732: l_payer_id VARCHAR2(80);
1733: l_payer_name HZ_PARTIES.PARTY_NAME%TYPE; --Changed the datatype for bug#5652085 by ehuh 2/28/07
1734: l_note_payer_type VARCHAR2(100);
1735: l_context_tab IEX_NOTES_PVT.CONTEXTS_TBL_TYPE;
1736: l_note_id NUMBER;
1737: l_cust_id number;

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

2059: l_promise_status varchar2(30); -- := 'CANCELLED';
2060: l_note_payer_id NUMBER;
2061: l_payer_num_id NUMBER;
2062: l_payer_id VARCHAR2(80);
2063: l_payer_name HZ_PARTIES.PARTY_NAME%TYPE; --Changed the datatype for bug#5652085 by ehuh 2/28/07
2064: l_note_payer_type VARCHAR2(100);
2065: l_context_tab IEX_NOTES_PVT.CONTEXTS_TBL_TYPE;
2066: l_note_id NUMBER;
2067: l_cust_id number;

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

2476: l_broken_on_date date;
2477: l_note_payer_id NUMBER;
2478: l_payer_num_id NUMBER;
2479: l_payer_id VARCHAR2(80);
2480: l_payer_name HZ_PARTIES.PARTY_NAME%TYPE; --Changed the datatype for bug#5652085 by ehuh 2/28/07
2481: l_note_payer_type VARCHAR2(100);
2482: l_context_tab IEX_NOTES_PVT.CONTEXTS_TBL_TYPE;
2483: l_note_id NUMBER;
2484: l_SQL VARCHAR2(1000);