APPS.PN_LEASE_DETAILS_SEND_UPD dependencies on PN_LEASES

Line 9: -- 14-JUL-05 hareesha o Bug 4284035 - Replaced pn_leases with _ALL table.

5: -- PROCDURE : UPDATE_LEASE_SE
6: -- INVOKED FROM :
7: -- PURPOSE :
8: -- HISTORY :
9: -- 14-JUL-05 hareesha o Bug 4284035 - Replaced pn_leases with _ALL table.
10: -------------------------------------------------------------------------------
11: PROCEDURE update_lease_se (
12: errbuf OUT NOCOPY VARCHAR2,
13: retcode OUT NOCOPY VARCHAR2,

Line 18: v_getleaseid pn_leases.lease_id%TYPE;

14: p_lease_class IN VARCHAR2,
15: p_lease_num_from IN VARCHAR2,
16: p_lease_num_to IN VARCHAR2)
17: IS
18: v_getleaseid pn_leases.lease_id%TYPE;
19: s_count NUMBER := 0;
20: l_lease_num pn_leases.lease_num%TYPE;
21: v_batch_size NUMBER := 1000;
22: v_counter NUMBER := 0;

Line 20: l_lease_num pn_leases.lease_num%TYPE;

16: p_lease_num_to IN VARCHAR2)
17: IS
18: v_getleaseid pn_leases.lease_id%TYPE;
19: s_count NUMBER := 0;
20: l_lease_num pn_leases.lease_num%TYPE;
21: v_batch_size NUMBER := 1000;
22: v_counter NUMBER := 0;
23: l_lastupdatedate DATE :=SYSDATE;
24: l_lastupdatedby NUMBER :=fnd_global.user_id;

Line 64: FROM pn_leases l, pn_lease_details_all d

60: d.attribute15,
61: d.accrual_account_id,
62: d.receivable_account_id,
63: d.term_template_id
64: FROM pn_leases l, pn_lease_details_all d
65: WHERE l.lease_id = d.lease_id
66: AND lease_num BETWEEN NVL(p_lease_num_from,lease_num) AND
67: NVL(p_lease_num_to,lease_num)
68: AND lease_class_code = NVL(p_lease_class,lease_class_code)