APPS.OKL_STREAM_MIGRATION_PVT dependencies on OKC_RULES_B

Line 396: FROM okc_rules_b rul,

392:
393: CURSOR pth_service_csr (l_sty_id NUMBER )
394: IS
395: SELECT rul.object1_id1
396: FROM okc_rules_b rul,
397: okc_rule_groups_b rgp,
398: okc_k_lines_b cleb,
399: okc_line_styles_b lseb,
400: okc_k_headers_b chrb,

Line 590: FROM okc_rules_b rul,

586:
587: CURSOR srv_pmt_csr (l_sty_id NUMBER) IS
588: --Service Payments
589: SELECT rul.object1_id1 --strm_type_id,
590: FROM okc_rules_b rul,
591: okc_rule_groups_b rgp,
592: okc_k_lines_b cleb,
593: okc_line_styles_b lseb,
594: okc_k_headers_b chrb,

Line 615: FROM okc_rules_b rul,

611: AND pdt.tax_owner IN ('LESSOR', 'LESSEE')
612: UNION ALL
613: --Link Service Payments
614: SELECT rul.object1_id1 --strm_type_id,
615: FROM okc_rules_b rul,
616: okc_rule_groups_b rgp,
617: okc_k_lines_b cleb,
618: okc_line_styles_b lseb,
619: okc_k_headers_b chrb,

Line 643: FROM okc_rules_b rul,

639:
640: CURSOR fee_pmt_csr (l_sty_id NUMBER) IS
641: --Fee Payments
642: SELECT rul.object1_id1 --strm_type_id,
643: FROM okc_rules_b rul,
644: okc_rule_groups_b rgp,
645: okc_k_lines_b cleb,
646: okc_line_styles_b lseb,
647: okc_k_headers_b chrb,

Line 668: FROM okc_rules_b rul,

664: AND pdt.tax_owner IN ('LESSOR', 'LESSEE')
665: UNION ALL
666: --Link Fee Payments
667: SELECT rul.object1_id1 --strm_type_id,
668: FROM okc_rules_b rul,
669: okc_rule_groups_b rgp,
670: okc_k_lines_b cleb,
671: okc_line_styles_b lseb,
672: okc_k_headers_b chrb,

Line 693: FROM okc_rules_b rul,

689: AND pdt.tax_owner IN ('LESSOR', 'LESSEE')
690: UNION ALL
691: --Contract level payments
692: SELECT rul.object1_id1 --strm_type_id,
693: FROM okc_rules_b rul,
694: okc_rule_groups_b rgp,
695: okc_k_headers_b chrb,
696: okl_k_headers khr,
697: okl_product_parameters_v pdt

Line 713: FROM okc_rules_b rul,

709: AND pdt.tax_owner IN ('LESSOR', 'LESSEE')
710: UNION ALL
711: --Asset level payments not RENT
712: SELECT rul.object1_id1 --strm_type_id,
713: FROM okc_rules_b rul,
714: okc_rule_groups_b rgp,
715: okc_k_lines_b cleb,
716: okc_line_styles_b lseb,
717: okc_k_headers_b chrb,

Line 985: FROM okc_rules_b rul,

981:
982: CURSOR pth_service_csr
983: IS
984: SELECT 'Y'
985: FROM okc_rules_b rul,
986: okc_rule_groups_b rgp,
987: okc_k_lines_b cleb,
988: okc_line_styles_b lseb,
989: okc_k_headers_b chrb,

Line 1012: FROM okc_rules_b rul,

1008:
1009: CURSOR srv_pmt_csr IS
1010: --Service Payments
1011: SELECT 'Y'
1012: FROM okc_rules_b rul,
1013: okc_rule_groups_b rgp,
1014: okc_k_lines_b cleb,
1015: okc_line_styles_b lseb,
1016: okc_k_headers_b chrb,

Line 1037: FROM okc_rules_b rul,

1033: AND pdt.TAX_OWNER = p_tax_owner
1034: UNION ALL
1035: --Link Service Payments
1036: SELECT 'Y'
1037: FROM okc_rules_b rul,
1038: okc_rule_groups_b rgp,
1039: okc_k_lines_b cleb,
1040: okc_line_styles_b lseb,
1041: okc_k_headers_b chrb,

Line 1065: FROM okc_rules_b rul,

1061:
1062: CURSOR fee_pmt_csr IS
1063: --Fee Payments
1064: SELECT 'Y'
1065: FROM okc_rules_b rul,
1066: okc_rule_groups_b rgp,
1067: okc_k_lines_b cleb,
1068: okc_line_styles_b lseb,
1069: okc_k_headers_b chrb,

Line 1090: FROM okc_rules_b rul,

1086: AND pdt.TAX_OWNER = p_tax_owner
1087: UNION ALL
1088: --Link Fee Payments
1089: SELECT 'Y'
1090: FROM okc_rules_b rul,
1091: okc_rule_groups_b rgp,
1092: okc_k_lines_b cleb,
1093: okc_line_styles_b lseb,
1094: okc_k_headers_b chrb,

Line 1115: FROM okc_rules_b rul,

1111: AND pdt.TAX_OWNER = p_tax_owner
1112: UNION ALL
1113: --Contract level payments
1114: SELECT 'Y'
1115: FROM okc_rules_b rul,
1116: okc_rule_groups_b rgp,
1117: okc_k_headers_b chrb,
1118: okl_k_headers khr,
1119: okl_product_parameters_v pdt

Line 1135: FROM okc_rules_b rul,

1131: AND pdt.TAX_OWNER = p_tax_owner
1132: UNION ALL
1133: --Asset level payments not RENT
1134: SELECT 'Y'
1135: FROM okc_rules_b rul,
1136: okc_rule_groups_b rgp,
1137: okc_k_lines_b cleb,
1138: okc_line_styles_b lseb,
1139: okc_k_headers_b chrb,