APPS.PN_DISTRIBUTION_ACCOUNT dependencies on PN_LEASES

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 33: l_lease_num pn_leases.lease_num%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;
34: l_lease_class_code pn_leases.lease_class_code%TYPE;
35: l_lia_rec_class pn_distributions.account_class%TYPE;
36: l_lia_rec_acc pn_distributions.account_id%TYPE;
37: l_accr_class pn_distributions.account_class%TYPE;

Line 34: l_lease_class_code pn_leases.lease_class_code%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;
34: l_lease_class_code pn_leases.lease_class_code%TYPE;
35: l_lia_rec_class pn_distributions.account_class%TYPE;
36: l_lia_rec_acc pn_distributions.account_id%TYPE;
37: l_accr_class pn_distributions.account_class%TYPE;
38: l_accr_acc pn_distributions.account_id%TYPE;

Line 109: pn_leases_all pl

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
111: AND pt.lease_id (+) = pl.lease_id
112: AND pt.location_id = pln.location_id (+)
113: AND pt.primary_flag (+) = :x_primary_flag