DBA Data[Home] [Help]

APPS.JA_CN_FSG_XML_SUBMIT_PROG dependencies on RG_ROW_ORDERS

Line 868: FROM rg_row_orders ro, rg_reports rp

864: --ROW_ORDER_ID
865: BEGIN
866: SELECT ro.row_order_id
867: INTO ln_row_order_id
868: FROM rg_row_orders ro, rg_reports rp
869: WHERE rp.report_id = pn_balance_sheet_id
870: AND rp.row_order_id = ro.row_order_id(+);
871: EXCEPTION
872: WHEN NO_DATA_FOUND THEN

Line 1001: FROM rg_row_orders ro, rg_reports rp

997: --ROW_ORDER_ID
998: BEGIN
999: SELECT ro.row_order_id
1000: INTO ln_row_order_id
1001: FROM rg_row_orders ro, rg_reports rp
1002: WHERE rp.report_id = pn_profit_statement_id
1003: AND rp.row_order_id = ro.row_order_id(+);
1004: EXCEPTION
1005: WHEN NO_DATA_FOUND THEN

Line 1135: FROM rg_row_orders ro, rg_reports rp

1131: --ROW_ORDER_ID
1132: BEGIN
1133: SELECT ro.row_order_id
1134: INTO ln_row_order_id
1135: FROM rg_row_orders ro, rg_reports rp
1136: WHERE rp.report_id = pn_owners_equity_id
1137: AND rp.row_order_id = ro.row_order_id(+);
1138: EXCEPTION
1139: WHEN NO_DATA_FOUND THEN

Line 1270: FROM rg_row_orders ro, rg_reports rp

1266: --ROW_ORDER_ID
1267: BEGIN
1268: SELECT ro.row_order_id
1269: INTO ln_row_order_id
1270: FROM rg_row_orders ro, rg_reports rp
1271: WHERE rp.report_id = pn_csf_report_id
1272: AND rp.row_order_id = ro.row_order_id(+);
1273: EXCEPTION
1274: WHEN NO_DATA_FOUND THEN

Line 1866: FROM rg_row_orders ro, rg_reports rp

1862: --ROW_ORDER_ID
1863: BEGIN
1864: SELECT ro.row_order_id
1865: INTO ln_row_order_id
1866: FROM rg_row_orders ro, rg_reports rp
1867: WHERE rp.report_id = pn_balance_sheet_id
1868: AND rp.row_order_id = ro.row_order_id(+);
1869: EXCEPTION
1870: WHEN NO_DATA_FOUND THEN

Line 1999: FROM rg_row_orders ro, rg_reports rp

1995: --ROW_ORDER_ID
1996: BEGIN
1997: SELECT ro.row_order_id
1998: INTO ln_row_order_id
1999: FROM rg_row_orders ro, rg_reports rp
2000: WHERE rp.report_id = pn_profit_statement_id
2001: AND rp.row_order_id = ro.row_order_id(+);
2002: EXCEPTION
2003: WHEN NO_DATA_FOUND THEN

Line 2133: FROM rg_row_orders ro, rg_reports rp

2129: --ROW_ORDER_ID
2130: BEGIN
2131: SELECT ro.row_order_id
2132: INTO ln_row_order_id
2133: FROM rg_row_orders ro, rg_reports rp
2134: WHERE rp.report_id = pn_owners_equity_id
2135: AND rp.row_order_id = ro.row_order_id(+);
2136: EXCEPTION
2137: WHEN NO_DATA_FOUND THEN

Line 2268: FROM rg_row_orders ro, rg_reports rp

2264: --ROW_ORDER_ID
2265: BEGIN
2266: SELECT ro.row_order_id
2267: INTO ln_row_order_id
2268: FROM rg_row_orders ro, rg_reports rp
2269: WHERE rp.report_id = pn_csf_report_id
2270: AND rp.row_order_id = ro.row_order_id(+);
2271: EXCEPTION
2272: WHEN NO_DATA_FOUND THEN