APPS.PN_CREATE_ACC dependencies on PN_LEASE_DETAILS_ALL

Line 1612: FROM pn_lease_details_all

1608: l_acc_cnt NUMBER := 0;
1609:
1610: CURSOR get_send_flag(p_lease_id NUMBER) IS
1611: SELECT nvl(send_entries, 'Y')
1612: FROM pn_lease_details_all
1613: WHERE lease_id = p_lease_id;
1614:
1615: CURSOR C_TERM IS
1616: SELECT pt.payment_term_id,

Line 1675: l_send_flag pn_lease_details_all.send_entries%TYPE := 'Y';

1671: l_period_name VARCHAR2(250);
1672: v_schedule_date DATE ;
1673: l_chart_of_id NUMBER;
1674:
1675: l_send_flag pn_lease_details_all.send_entries%TYPE := 'Y';
1676: l_lease_id NUMBER := 0;
1677:
1678: -- variables for accounted amt.
1679: l_item_accounted_amt NUMBER;

Line 2365: FROM pn_lease_details_all

2361: l_acc_cnt NUMBER := 0;
2362:
2363: CURSOR get_send_flag(p_lease_id NUMBER) IS
2364: SELECT nvl(send_entries, 'Y')
2365: FROM pn_lease_details_all
2366: WHERE lease_id = p_lease_id;
2367:
2368: CURSOR C_TERM IS
2369: SELECT pt.payment_term_id,

Line 2429: l_send_flag pn_lease_details_all.send_entries%TYPE := 'Y';

2425: l_period_name varchar2(250);
2426: l_chart_of_id number;
2427: v_schedule_date date ;
2428:
2429: l_send_flag pn_lease_details_all.send_entries%TYPE := 'Y';
2430: l_lease_id NUMBER := 0;
2431:
2432: -- variables for accounted amt.
2433: l_item_accounted_amt NUMBER;