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 979: FROM okl_strm_tmpt_full_uv

975: and OKL_STRMTYP.STATUS = 'A';
976:
977: Cursor l_ft_capitalized_item_id_csr(p_pdt_id okl_k_headers.pdt_id%type, p_start_date date) IS
978: SELECT sty_id
979: FROM okl_strm_tmpt_full_uv
980: WHERE nvl(CAPITALIZE_YN,'N') = 'Y'
981: AND STY_PURPOSE = 'EXPENSE'
982: AND pdt_id = p_pdt_id
983: AND trunc(p_start_date) BETWEEN trunc(okl_strm_tmpt_full_uv.START_DATE)

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

979: FROM okl_strm_tmpt_full_uv
980: WHERE nvl(CAPITALIZE_YN,'N') = 'Y'
981: AND STY_PURPOSE = 'EXPENSE'
982: AND pdt_id = p_pdt_id
983: AND trunc(p_start_date) BETWEEN trunc(okl_strm_tmpt_full_uv.START_DATE)
984: AND nvl(trunc(okl_strm_tmpt_full_uv.END_DATE),p_start_date+1)
985: AND sty_name = p_fee_types_rec.item_name;
986:
987: Cursor l_ft_income_item_id_csr(p_pdt_id okl_k_headers.pdt_id%type, p_start_date date) IS

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

980: WHERE nvl(CAPITALIZE_YN,'N') = 'Y'
981: AND STY_PURPOSE = 'EXPENSE'
982: AND pdt_id = p_pdt_id
983: AND trunc(p_start_date) BETWEEN trunc(okl_strm_tmpt_full_uv.START_DATE)
984: AND nvl(trunc(okl_strm_tmpt_full_uv.END_DATE),p_start_date+1)
985: AND sty_name = p_fee_types_rec.item_name;
986:
987: Cursor l_ft_income_item_id_csr(p_pdt_id okl_k_headers.pdt_id%type, p_start_date date) IS
988: SELECT sty_id

Line 989: FROM okl_strm_tmpt_full_uv

985: AND sty_name = p_fee_types_rec.item_name;
986:
987: Cursor l_ft_income_item_id_csr(p_pdt_id okl_k_headers.pdt_id%type, p_start_date date) IS
988: SELECT sty_id
989: FROM okl_strm_tmpt_full_uv
990: WHERE STY_PURPOSE = 'FEE_PAYMENT'
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)

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

988: SELECT sty_id
989: FROM okl_strm_tmpt_full_uv
990: WHERE STY_PURPOSE = 'FEE_PAYMENT'
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_passthrough_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: FROM okl_strm_tmpt_full_uv
990: WHERE STY_PURPOSE = 'FEE_PAYMENT'
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_passthrough_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_passthrough_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 = 'PASS_THROUGH_FEE'
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 = 'PASS_THROUGH_FEE'
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_secdeposit_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 = 'PASS_THROUGH_FEE'
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_secdeposit_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_secdeposit_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 = 'SECURITY_DEPOSIT'
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 = 'SECURITY_DEPOSIT'
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_others_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 = 'SECURITY_DEPOSIT'
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_others_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_others_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 = 'EXPENSE'
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 = 'EXPENSE'
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_item_name_csr 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 = 'EXPENSE'
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_item_name_csr IS
1024: select name