DBA Data[Home] [Help]

APPS.PN_CREATE_ACC dependencies on PN_LEASE_DETAILS_ALL

Line 1144: FROM pn_lease_details_all

1140: l_acc_cnt NUMBER := 0;
1141:
1142: CURSOR get_send_flag(p_lease_id NUMBER) IS
1143: SELECT nvl(send_entries, 'Y')
1144: FROM pn_lease_details_all
1145: WHERE lease_id = p_lease_id;
1146:
1147: CURSOR C_TERM IS
1148: SELECT pt.payment_term_id,

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

1203: l_period_name VARCHAR2(250);
1204: v_schedule_date DATE ;
1205: l_chart_of_id NUMBER;
1206:
1207: l_send_flag pn_lease_details_all.send_entries%TYPE := 'Y';
1208: l_lease_id NUMBER := 0;
1209:
1210: -- variables for accounted amt.
1211: l_item_accounted_amt NUMBER;

Line 1897: FROM pn_lease_details_all

1893: l_acc_cnt NUMBER := 0;
1894:
1895: CURSOR get_send_flag(p_lease_id NUMBER) IS
1896: SELECT nvl(send_entries, 'Y')
1897: FROM pn_lease_details_all
1898: WHERE lease_id = p_lease_id;
1899:
1900: CURSOR C_TERM IS
1901: SELECT pt.payment_term_id,

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

1957: l_period_name varchar2(250);
1958: l_chart_of_id number;
1959: v_schedule_date date ;
1960:
1961: l_send_flag pn_lease_details_all.send_entries%TYPE := 'Y';
1962: l_lease_id NUMBER := 0;
1963:
1964: -- variables for accounted amt.
1965: l_item_accounted_amt NUMBER;