DBA Data[Home] [Help]

APPS.GMICCAL dependencies on IC_CLDR_HDR

Line 70: FROM ic_cldr_hdr

66: /* Cursor Definitions
67: ================== */
68: CURSOR get_yr_begin_date IS
69: SELECT max(begin_date)
70: FROM ic_cldr_hdr
71: WHERE begin_date <= trans_date
72: AND delete_mark = 0
73: AND UPPER(orgn_code) = UPPER(lp_co_code);
74:

Line 77: FROM ic_cldr_hdr

73: AND UPPER(orgn_code) = UPPER(lp_co_code);
74:
75: CURSOR get_fiscal_yr IS
76: SELECT fiscal_year
77: FROM ic_cldr_hdr
78: WHERE begin_date = l_begin_date
79: AND delete_mark = 0
80: AND orgn_code = UPPER(lp_co_code);
81: