APPS.PN_DISTRIBUTION_ACCOUNT dependencies on PN_PAYMENT_TERMS

Line 9: -- 14-JUL-05 hareesha o Bug 4284035 - Replaced pn_payment_terms,pn_leases,

5: -- PROCDURE : CREATE_ACCOUNTS
6: -- INVOKED FROM :
7: -- PURPOSE :
8: -- HISTORY :
9: -- 14-JUL-05 hareesha o Bug 4284035 - Replaced pn_payment_terms,pn_leases,
10: -- pn_locations with _ALL table.
11: -- 25-OCT-05 Hareesha o ATG mandated changes for SQL literals using dbms_sql.
12: -------------------------------------------------------------------------------
13: PROCEDURE create_accounts (

Line 28: l_payment_term_id pn_payment_terms.payment_term_id%TYPE;

24: p_lia_ccid IN NUMBER ,
25: p_accr_liab_ccid IN NUMBER
26: ) IS
27:
28: l_payment_term_id pn_payment_terms.payment_term_id%TYPE;
29: l_normalize pn_payment_terms.normalize%TYPE;
30: l_org_id NUMBER;
31: l_project_id NUMBER;
32: l_distribution_set_id NUMBER;

Line 29: l_normalize pn_payment_terms.normalize%TYPE;

25: p_accr_liab_ccid IN NUMBER
26: ) IS
27:
28: l_payment_term_id pn_payment_terms.payment_term_id%TYPE;
29: l_normalize pn_payment_terms.normalize%TYPE;
30: l_org_id NUMBER;
31: l_project_id NUMBER;
32: l_distribution_set_id NUMBER;
33: l_lease_num pn_leases.lease_num%TYPE;

Line 106: FROM pn_payment_terms ppt,

102: ppt.org_id,
103: ppt.distribution_set_id,
104: ppt.project_id,
105: pl.lease_class_code
106: FROM pn_payment_terms ppt,
107: pn_tenancies_all pt,
108: pn_locations_all pln,
109: pn_leases_all pl
110: WHERE ppt.lease_id = pl.lease_id

Line 333: SELECT org_id FROM pn_payment_terms_all WHERE payment_term_ID = p_payment_term_id;

329: l_context VARCHAR2(2000);
330: l_line_number pn_distributions.line_number%TYPE;
331:
332: CURSOR org_cur IS
333: SELECT org_id FROM pn_payment_terms_all WHERE payment_term_ID = p_payment_term_id;
334:
335: l_org_ID NUMBER;
336: BEGIN
337: