eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_MAINTAIN_FEE_PVT dependencies on OKL_STRM_TMPT_FULL_UV

Line 988: FROM okl_strm_tmpt_full_uv

984: and OKL_STRMTYP.STATUS = 'A';
985:
986: Cursor l_ft_capitalized_item_id_csr(p_pdt_id okl_k_headers.pdt_id%type, p_start_date date) IS
987: SELECT sty_id
988: FROM okl_strm_tmpt_full_uv
989: WHERE nvl(CAPITALIZE_YN,'N') = 'Y'
990: AND STY_PURPOSE = 'EXPENSE'
991: AND pdt_id = p_pdt_id
992: AND trunc(p_start_date) BETWEEN trunc(okl_strm_tmpt_full_uv.START_DATE)

Line 992: AND trunc(p_start_date) BETWEEN trunc(okl_strm_tmpt_full_uv.START_DATE)

988: FROM okl_strm_tmpt_full_uv
989: WHERE nvl(CAPITALIZE_YN,'N') = 'Y'
990: AND STY_PURPOSE = 'EXPENSE'
991: AND pdt_id = p_pdt_id
992: AND trunc(p_start_date) BETWEEN trunc(okl_strm_tmpt_full_uv.START_DATE)
993: AND nvl(trunc(okl_strm_tmpt_full_uv.END_DATE),p_start_date+1)
994: AND sty_name = p_fee_types_rec.item_name;
995:
996: Cursor l_ft_income_item_id_csr(p_pdt_id okl_k_headers.pdt_id%type, p_start_date date) IS

Line 993: AND nvl(trunc(okl_strm_tmpt_full_uv.END_DATE),p_start_date+1)

989: WHERE nvl(CAPITALIZE_YN,'N') = 'Y'
990: AND STY_PURPOSE = 'EXPENSE'
991: AND pdt_id = p_pdt_id
992: AND trunc(p_start_date) BETWEEN trunc(okl_strm_tmpt_full_uv.START_DATE)
993: AND nvl(trunc(okl_strm_tmpt_full_uv.END_DATE),p_start_date+1)
994: AND sty_name = p_fee_types_rec.item_name;
995:
996: Cursor l_ft_income_item_id_csr(p_pdt_id okl_k_headers.pdt_id%type, p_start_date date) IS
997: SELECT sty_id

Line 998: FROM okl_strm_tmpt_full_uv

994: AND sty_name = p_fee_types_rec.item_name;
995:
996: Cursor l_ft_income_item_id_csr(p_pdt_id okl_k_headers.pdt_id%type, p_start_date date) IS
997: SELECT sty_id
998: FROM okl_strm_tmpt_full_uv
999: WHERE STY_PURPOSE = 'FEE_PAYMENT'
1000: AND pdt_id = p_pdt_id
1001: AND trunc(p_start_date) BETWEEN trunc(okl_strm_tmpt_full_uv.START_DATE)
1002: AND nvl(trunc(okl_strm_tmpt_full_uv.END_DATE),p_start_date+1)

Line 1001: AND trunc(p_start_date) BETWEEN trunc(okl_strm_tmpt_full_uv.START_DATE)

997: SELECT sty_id
998: FROM okl_strm_tmpt_full_uv
999: WHERE STY_PURPOSE = 'FEE_PAYMENT'
1000: AND pdt_id = p_pdt_id
1001: AND trunc(p_start_date) BETWEEN trunc(okl_strm_tmpt_full_uv.START_DATE)
1002: AND nvl(trunc(okl_strm_tmpt_full_uv.END_DATE),p_start_date+1)
1003: AND sty_name = p_fee_types_rec.item_name;
1004:
1005: Cursor l_ft_passthrough_item_id_csr(p_pdt_id okl_k_headers.pdt_id%type, p_start_date date) IS

Line 1002: AND nvl(trunc(okl_strm_tmpt_full_uv.END_DATE),p_start_date+1)

998: FROM okl_strm_tmpt_full_uv
999: WHERE STY_PURPOSE = 'FEE_PAYMENT'
1000: AND pdt_id = p_pdt_id
1001: AND trunc(p_start_date) BETWEEN trunc(okl_strm_tmpt_full_uv.START_DATE)
1002: AND nvl(trunc(okl_strm_tmpt_full_uv.END_DATE),p_start_date+1)
1003: AND sty_name = p_fee_types_rec.item_name;
1004:
1005: Cursor l_ft_passthrough_item_id_csr(p_pdt_id okl_k_headers.pdt_id%type, p_start_date date) IS
1006: SELECT sty_id

Line 1007: FROM okl_strm_tmpt_full_uv

1003: AND sty_name = p_fee_types_rec.item_name;
1004:
1005: Cursor l_ft_passthrough_item_id_csr(p_pdt_id okl_k_headers.pdt_id%type, p_start_date date) IS
1006: SELECT sty_id
1007: FROM okl_strm_tmpt_full_uv
1008: WHERE STY_PURPOSE = 'PASS_THROUGH_FEE'
1009: AND pdt_id = p_pdt_id
1010: AND trunc(p_start_date) BETWEEN trunc(okl_strm_tmpt_full_uv.START_DATE)
1011: AND nvl(trunc(okl_strm_tmpt_full_uv.END_DATE),p_start_date+1)

Line 1010: AND trunc(p_start_date) BETWEEN trunc(okl_strm_tmpt_full_uv.START_DATE)

1006: SELECT sty_id
1007: FROM okl_strm_tmpt_full_uv
1008: WHERE STY_PURPOSE = 'PASS_THROUGH_FEE'
1009: AND pdt_id = p_pdt_id
1010: AND trunc(p_start_date) BETWEEN trunc(okl_strm_tmpt_full_uv.START_DATE)
1011: AND nvl(trunc(okl_strm_tmpt_full_uv.END_DATE),p_start_date+1)
1012: AND sty_name = p_fee_types_rec.item_name;
1013:
1014: Cursor l_ft_secdeposit_item_id_csr(p_pdt_id okl_k_headers.pdt_id%type, p_start_date date) IS

Line 1011: AND nvl(trunc(okl_strm_tmpt_full_uv.END_DATE),p_start_date+1)

1007: FROM okl_strm_tmpt_full_uv
1008: WHERE STY_PURPOSE = 'PASS_THROUGH_FEE'
1009: AND pdt_id = p_pdt_id
1010: AND trunc(p_start_date) BETWEEN trunc(okl_strm_tmpt_full_uv.START_DATE)
1011: AND nvl(trunc(okl_strm_tmpt_full_uv.END_DATE),p_start_date+1)
1012: AND sty_name = p_fee_types_rec.item_name;
1013:
1014: Cursor l_ft_secdeposit_item_id_csr(p_pdt_id okl_k_headers.pdt_id%type, p_start_date date) IS
1015: SELECT sty_id

Line 1016: FROM okl_strm_tmpt_full_uv

1012: AND sty_name = p_fee_types_rec.item_name;
1013:
1014: Cursor l_ft_secdeposit_item_id_csr(p_pdt_id okl_k_headers.pdt_id%type, p_start_date date) IS
1015: SELECT sty_id
1016: FROM okl_strm_tmpt_full_uv
1017: WHERE STY_PURPOSE = 'SECURITY_DEPOSIT'
1018: AND pdt_id = p_pdt_id
1019: AND trunc(p_start_date) BETWEEN trunc(okl_strm_tmpt_full_uv.START_DATE)
1020: AND nvl(trunc(okl_strm_tmpt_full_uv.END_DATE),p_start_date+1)

Line 1019: AND trunc(p_start_date) BETWEEN trunc(okl_strm_tmpt_full_uv.START_DATE)

1015: SELECT sty_id
1016: FROM okl_strm_tmpt_full_uv
1017: WHERE STY_PURPOSE = 'SECURITY_DEPOSIT'
1018: AND pdt_id = p_pdt_id
1019: AND trunc(p_start_date) BETWEEN trunc(okl_strm_tmpt_full_uv.START_DATE)
1020: AND nvl(trunc(okl_strm_tmpt_full_uv.END_DATE),p_start_date+1)
1021: AND sty_name = p_fee_types_rec.item_name;
1022:
1023: Cursor l_ft_others_item_id_csr(p_pdt_id okl_k_headers.pdt_id%type, p_start_date date) IS

Line 1020: AND nvl(trunc(okl_strm_tmpt_full_uv.END_DATE),p_start_date+1)

1016: FROM okl_strm_tmpt_full_uv
1017: WHERE STY_PURPOSE = 'SECURITY_DEPOSIT'
1018: AND pdt_id = p_pdt_id
1019: AND trunc(p_start_date) BETWEEN trunc(okl_strm_tmpt_full_uv.START_DATE)
1020: AND nvl(trunc(okl_strm_tmpt_full_uv.END_DATE),p_start_date+1)
1021: AND sty_name = p_fee_types_rec.item_name;
1022:
1023: Cursor l_ft_others_item_id_csr(p_pdt_id okl_k_headers.pdt_id%type, p_start_date date) IS
1024: SELECT sty_id

Line 1025: FROM okl_strm_tmpt_full_uv

1021: AND sty_name = p_fee_types_rec.item_name;
1022:
1023: Cursor l_ft_others_item_id_csr(p_pdt_id okl_k_headers.pdt_id%type, p_start_date date) IS
1024: SELECT sty_id
1025: FROM okl_strm_tmpt_full_uv
1026: WHERE STY_PURPOSE = 'EXPENSE'
1027: AND pdt_id = p_pdt_id
1028: AND trunc(p_start_date) BETWEEN trunc(okl_strm_tmpt_full_uv.START_DATE)
1029: AND nvl(trunc(okl_strm_tmpt_full_uv.END_DATE),p_start_date+1)

Line 1028: AND trunc(p_start_date) BETWEEN trunc(okl_strm_tmpt_full_uv.START_DATE)

1024: SELECT sty_id
1025: FROM okl_strm_tmpt_full_uv
1026: WHERE STY_PURPOSE = 'EXPENSE'
1027: AND pdt_id = p_pdt_id
1028: AND trunc(p_start_date) BETWEEN trunc(okl_strm_tmpt_full_uv.START_DATE)
1029: AND nvl(trunc(okl_strm_tmpt_full_uv.END_DATE),p_start_date+1)
1030: AND sty_name = p_fee_types_rec.item_name;
1031:
1032: CURSOR l_item_name_csr IS

Line 1029: AND nvl(trunc(okl_strm_tmpt_full_uv.END_DATE),p_start_date+1)

1025: FROM okl_strm_tmpt_full_uv
1026: WHERE STY_PURPOSE = 'EXPENSE'
1027: AND pdt_id = p_pdt_id
1028: AND trunc(p_start_date) BETWEEN trunc(okl_strm_tmpt_full_uv.START_DATE)
1029: AND nvl(trunc(okl_strm_tmpt_full_uv.END_DATE),p_start_date+1)
1030: AND sty_name = p_fee_types_rec.item_name;
1031:
1032: CURSOR l_item_name_csr IS
1033: select name