DBA Data[Home] [Help]

APPS.PN_CREATE_ACC dependencies on PN_AE_HEADERS_ALL

Line 1246: FROM pn_ae_headers_all pnh,

1242:
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:

Line 1922: INSERT INTO PN_AE_HEADERS_ALL

1918:
1919: l_header_desc := 'Property Manager - '|| 'Lease Number - ' ||v_pn_lease_num ; --Bug#5739873
1920:
1921:
1922: INSERT INTO PN_AE_HEADERS_ALL
1923: (AE_HEADER_ID ,
1924: ACCOUNTING_EVENT_ID ,
1925: SET_OF_BOOKS_ID ,
1926: AE_CATEGORY ,

Line 2680: INSERT INTO PN_AE_HEADERS_ALL

2676: CLOSE c_lease_num;
2677:
2678: l_header_desc := 'Property Manager - '|| 'Lease Number - ' ||v_pn_lease_num ; --Bug#5739873
2679:
2680: INSERT INTO PN_AE_HEADERS_ALL
2681: (
2682: AE_HEADER_ID ,
2683: ACCOUNTING_EVENT_ID ,
2684: SET_OF_BOOKS_ID ,