APPS.OKL_REPORT_GENERATOR_PVT dependencies on OKL_REPORTS_B

Line 651: ,okl_reports_b rep

647: ,okl_k_headers khr
648: ,okl_products pdt
649: ,okl_ae_tmpt_sets_all aes
650: ,okl_st_gen_tmpt_sets_all gts
651: ,okl_reports_b rep
652: ,okl_report_trx_params rtryp
653: ,okl_rep_products_gt pdt_gt
654: -- To fetch Names
655: ,hr_operating_units ou

Line 763: ,okl_reports_b rep

759: ,okl_k_headers khr
760: ,okl_products pdt
761: ,okl_ae_tmpt_sets_all aes
762: ,okl_st_gen_tmpt_sets_all gts
763: ,okl_reports_b rep
764: ,okl_report_trx_params rtryp
765: ,okl_rep_products_gt pdt_gt
766: -- To fetch Names
767: ,hr_operating_units ou

Line 890: ,okl_reports_b rep

886: ,xla_ae_lines xl
887: ,xla_events xe
888: ,xla_event_types_vl xvl
889: -- OLM Reconciliation Report Definitions Table
890: ,okl_reports_b rep
891: ,okl_report_trx_params rtryp
892: ,okl_rep_products_gt pdt_gt
893: -- To fetch Names
894: ,gl_code_combinations_kfv glcc

Line 1037: ,okl_reports_b rep

1033: ,gl_import_references gi
1034: ,gl_je_headers gh
1035: ,gl_je_lines gl
1036: -- OKL Report Definition Tables
1037: ,okl_reports_b rep
1038: ,okl_report_trx_params rtryp
1039: ,okl_rep_products_gt pdt_gt
1040: -- To fetch Names
1041: ,gl_code_combinations_kfv glcc

Line 1269: ,okl_reports_b rep

1265: ,okl_st_gen_tmpt_sets_all gts
1266: ,okl_trx_types_v try
1267: ,okl_strm_type_v sty
1268: -- OLM Reconciliation Report Entities
1269: ,okl_reports_b rep
1270: ,okl_report_trx_params rtryp
1271: ,okl_rep_products_gt pdt_gt
1272: -- To fetch Names
1273: ,hr_operating_units ou

Line 1396: ,okl_reports_b rep

1392: -- XLA Tables
1393: ,xla_events xe
1394: ,xla_event_types_vl xvl
1395: -- OLM Reconciliation Report Entities
1396: ,okl_reports_b rep
1397: ,okl_report_trx_params rtryp
1398: ,okl_rep_products_gt pdt_gt
1399: -- To fetch Names
1400: ,hr_operating_units ou

Line 1523: ,okl_reports_b rep

1519: ,xla_distribution_links xd
1520: ,xla_ae_headers xh
1521: ,xla_ae_lines xl
1522: -- OLM Reconciliation Report Entities
1523: ,okl_reports_b rep
1524: ,okl_report_trx_params rtryp
1525: ,okl_rep_products_gt pdt_gt
1526: -- To fetch Names
1527: ,hr_operating_units ou

Line 1679: ,okl_reports_b rep

1675: ,gl_je_headers gh
1676: ,gl_je_lines gl
1677: ,gl_code_combinations_kfv glcc
1678: -- OLM Reconciliation Report Entities
1679: ,okl_reports_b rep
1680: ,okl_report_trx_params rtryp
1681: ,okl_rep_products_gt pdt_gt
1682: -- To fetch Names
1683: ,hr_operating_units ou

Line 1920: ,okl_reports_b rep

1916: ,okl_st_gen_tmpt_sets_all gts
1917: ,okl_trx_types_v try
1918: ,okl_strm_type_v sty
1919: -- OLM Reconciliation Report Entities
1920: ,okl_reports_b rep
1921: ,okl_report_trx_params rtryp
1922: ,okl_rep_products_gt pdt_gt
1923: -- To fetch Names
1924: ,hr_operating_units ou

Line 2026: ,okl_reports_b rep

2022: -- XLA Tables
2023: ,xla_events xe
2024: ,xla_event_types_vl xvl
2025: -- OLM Reconciliation Report Entities
2026: ,okl_reports_b rep
2027: ,okl_report_trx_params rtryp
2028: ,okl_rep_products_gt pdt_gt
2029: -- To fetch Names
2030: ,hr_operating_units ou

Line 2144: ,okl_reports_b rep

2140: -- AR Tables
2141: ,ar_adjustments_all radj
2142: ,ar_distributions_all rdist
2143: -- OLM Reconciliation Report Entities
2144: ,okl_reports_b rep
2145: ,okl_report_trx_params rtryp
2146: ,okl_rep_products_gt pdt_gt
2147: -- To fetch Names
2148: ,hr_operating_units ou

Line 2294: ,okl_reports_b rep

2290: -- AR Tables
2291: ,ar_adjustments_all radj
2292: ,ar_distributions_all rdist
2293: -- OLM Reconciliation Report Entities
2294: ,okl_reports_b rep
2295: ,okl_report_trx_params rtryp
2296: ,okl_rep_products_gt pdt_gt
2297: -- To fetch Names
2298: ,hr_operating_units ou

Line 2537: ,okl_reports_b rep

2533: ,okl_st_gen_tmpt_sets_all gts
2534: ,okl_trx_types_v try
2535: ,okl_strm_type_v sty
2536: -- OLM Reconciliation Report Entities
2537: ,okl_reports_b rep
2538: ,okl_report_trx_params rtryp
2539: ,okl_rep_products_gt pdt_gt
2540: -- To fetch Names
2541: ,hr_operating_units ou

Line 2661: ,okl_reports_b rep

2657: -- XLA Tables
2658: ,xla_events xe
2659: ,xla_event_types_vl xvl
2660: -- OLM Reconciliation Report Entities
2661: ,okl_reports_b rep
2662: ,okl_report_trx_params rtryp
2663: ,okl_rep_products_gt pdt_gt
2664: -- To fetch Names
2665: ,hr_operating_units ou

Line 2798: ,okl_reports_b rep

2794: ,xla_distribution_links xd
2795: ,xla_ae_headers xh
2796: ,xla_ae_lines xl
2797: -- OLM Reconciliation Report Entities
2798: ,okl_reports_b rep
2799: ,okl_report_trx_params rtryp
2800: ,okl_rep_products_gt pdt_gt
2801: -- To fetch Names
2802: ,hr_operating_units ou

Line 2963: ,okl_reports_b rep

2959: ,gl_import_references gi
2960: ,gl_je_headers gh
2961: ,gl_je_lines gl
2962: -- OLM Reconciliation Report Entities
2963: ,okl_reports_b rep
2964: ,okl_report_trx_params rtryp
2965: ,okl_rep_products_gt pdt_gt
2966: -- To fetch Names
2967: ,hr_operating_units ou

Line 3146: FROM okl_reports_b rep

3142: -- Cursor to find the Activity Code on the Reconciliation Report Definition
3143: CURSOR get_activity_code_csr( p_report_id NUMBER)
3144: IS
3145: SELECT activity_code activity_code
3146: FROM okl_reports_b rep
3147: WHERE rep.report_id = p_report_id;
3148: ------------------------------------------------------------------------
3149: -- Important: Logic to find the Stream Balances as on a particular Date
3150: -- Inputs :