DBA Data[Home] [Help]

APPS.OKL_GENERATE_ACCRUALS_PVT dependencies on OKL_ACCRUAL_GNRTNS

Line 920: -- FROM OKL_ACCRUAL_GNRTNS_UV

916: -- ,right_operand_literal
917: -- ,right_parentheses_meaning
918: -- ,from_date
919: -- ,TO_DATE
920: -- FROM OKL_ACCRUAL_GNRTNS_UV
921: -- WHERE VERSION = (SELECT MAX(TO_NUMBER(version))
922: -- FROM OKL_ACCRUAL_GNRTNS_UV)
923: -- AND TO_DATE IS NULL
924: -- ORDER BY LINE_NUMBER;

Line 922: -- FROM OKL_ACCRUAL_GNRTNS_UV)

918: -- ,from_date
919: -- ,TO_DATE
920: -- FROM OKL_ACCRUAL_GNRTNS_UV
921: -- WHERE VERSION = (SELECT MAX(TO_NUMBER(version))
922: -- FROM OKL_ACCRUAL_GNRTNS_UV)
923: -- AND TO_DATE IS NULL
924: -- ORDER BY LINE_NUMBER;
925:
926: CURSOR accrual_rule_csr IS

Line 935: FROM OKL_ACCRUAL_GNRTNS

931: ,right_operand_literal
932: ,OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING_LANG('OKL_PARENTHESIS',right_parentheses,540,0,'US') right_parentheses_meaning
933: ,from_date
934: ,to_date
935: FROM OKL_ACCRUAL_GNRTNS
936: WHERE to_number(VERSION) = (SELECT MAX(to_number(version))
937: FROM OKL_ACCRUAL_GNRTNS)
938: AND TO_DATE IS NULL
939: ORDER BY LINE_NUMBER;

Line 937: FROM OKL_ACCRUAL_GNRTNS)

933: ,from_date
934: ,to_date
935: FROM OKL_ACCRUAL_GNRTNS
936: WHERE to_number(VERSION) = (SELECT MAX(to_number(version))
937: FROM OKL_ACCRUAL_GNRTNS)
938: AND TO_DATE IS NULL
939: ORDER BY LINE_NUMBER;
940:
941: l_string VARCHAR2(2000);