DBA Data[Home] [Help]

APPS.PN_CREATE_ACC dependencies on PN_AE_LINES_ALL

Line 1247: pn_ae_lines_all pnl

1243: CURSOR c_min_max_date IS
1244: SELECT min(accounting_date),
1245: max(accounting_date)
1246: FROM pn_ae_headers_all pnh,
1247: pn_ae_lines_all pnl
1248: WHERE pnh.ae_header_id = pnl.ae_header_id
1249: AND pnl.gl_sl_link_id IS NULL ;
1250:
1251: BEGIN

Line 2017: INSERT INTO PN_AE_LINES_ALL

2013:
2014: l_line_desc := 'Property Manager - '|| 'Lease Number - ' ||v_pn_lease_num ; --Bug#5739873
2015: l_rev_number := l_rev_number + 1;
2016:
2017: INSERT INTO PN_AE_LINES_ALL
2018: (
2019: AE_LINE_ID ,
2020: AE_HEADER_ID ,
2021: AE_LINE_NUMBER ,

Line 2131: INSERT INTO PN_AE_LINES_ALL

2127: l_line_desc := 'Property Manager - '|| 'Lease Number - ' ||v_pn_lease_num ; --Bug#5739873
2128:
2129: l_unearn_number := l_unearn_number + 1;
2130:
2131: INSERT INTO PN_AE_LINES_ALL
2132: (
2133: AE_LINE_ID ,
2134: AE_HEADER_ID ,
2135: AE_LINE_NUMBER ,

Line 2777: INSERT INTO PN_AE_LINES_ALL

2773:
2774: l_line_desc := 'Property Manager - '|| 'Lease Number - ' ||v_pn_lease_num ; --Bug#5739873
2775: l_exp_number := l_exp_number +1;
2776:
2777: INSERT INTO PN_AE_LINES_ALL
2778: (
2779: AE_LINE_ID ,
2780: AE_HEADER_ID ,
2781: AE_LINE_NUMBER ,

Line 2892: INSERT INTO PN_AE_LINES_ALL

2888:
2889:
2890: l_acc_number := l_acc_number +1;
2891:
2892: INSERT INTO PN_AE_LINES_ALL
2893: (
2894: AE_LINE_ID ,
2895: AE_HEADER_ID ,
2896: AE_LINE_NUMBER ,