DBA Data[Home] [Help]

APPS.PN_CREATE_ACC dependencies on PN_AE_LINES_ALL

Line 779: pn_ae_lines_all pnl

775: CURSOR c_min_max_date IS
776: SELECT min(accounting_date),
777: max(accounting_date)
778: FROM pn_ae_headers_all pnh,
779: pn_ae_lines_all pnl
780: WHERE pnh.ae_header_id = pnl.ae_header_id
781: AND pnl.gl_sl_link_id IS NULL ;
782:
783: BEGIN

Line 1549: INSERT INTO PN_AE_LINES_ALL

1545:
1546: l_line_desc := 'Property Manager - '|| 'Lease Number - ' ||v_pn_lease_num ; --Bug#5739873
1547: l_rev_number := l_rev_number + 1;
1548:
1549: INSERT INTO PN_AE_LINES_ALL
1550: (
1551: AE_LINE_ID ,
1552: AE_HEADER_ID ,
1553: AE_LINE_NUMBER ,

Line 1663: INSERT INTO PN_AE_LINES_ALL

1659: l_line_desc := 'Property Manager - '|| 'Lease Number - ' ||v_pn_lease_num ; --Bug#5739873
1660:
1661: l_unearn_number := l_unearn_number + 1;
1662:
1663: INSERT INTO PN_AE_LINES_ALL
1664: (
1665: AE_LINE_ID ,
1666: AE_HEADER_ID ,
1667: AE_LINE_NUMBER ,

Line 2309: INSERT INTO PN_AE_LINES_ALL

2305:
2306: l_line_desc := 'Property Manager - '|| 'Lease Number - ' ||v_pn_lease_num ; --Bug#5739873
2307: l_exp_number := l_exp_number +1;
2308:
2309: INSERT INTO PN_AE_LINES_ALL
2310: (
2311: AE_LINE_ID ,
2312: AE_HEADER_ID ,
2313: AE_LINE_NUMBER ,

Line 2424: INSERT INTO PN_AE_LINES_ALL

2420:
2421:
2422: l_acc_number := l_acc_number +1;
2423:
2424: INSERT INTO PN_AE_LINES_ALL
2425: (
2426: AE_LINE_ID ,
2427: AE_HEADER_ID ,
2428: AE_LINE_NUMBER ,