APPS.QPR_MAINTAIN_AW dependencies on QPR_TIME_ALLHIER_V

Line 22: from qpr_time_allhier_v

18:
19: if p_low_lvl_time = 'MONTH' then
20: begin
21: select day into i_date
22: from qpr_time_allhier_v
23: where month = p_time_pk
24: and rownum<2;
25: exception
26: when others then null;

Line 31: from qpr_time_allhier_v

27: end;
28: elsif p_low_lvl_time = 'FISCAL_MONTH' then
29: begin
30: select day into i_date
31: from qpr_time_allhier_v
32: where fiscal_month = p_time_pk
33: and rownum<2;
34: exception
35: when others then null;

Line 40: from qpr_time_allhier_v

36: end;
37: elsif p_low_lvl_time = 'QUARTER' then
38: begin
39: select day into i_date
40: from qpr_time_allhier_v
41: where quarter = p_time_pk
42: and rownum<2;
43: exception
44: when others then null;

Line 49: from qpr_time_allhier_v

45: end;
46: elsif p_low_lvl_time = 'FISCAL_QUARTER' then
47: begin
48: select day into i_date
49: from qpr_time_allhier_v
50: where fiscal_quarter = p_time_pk
51: and rownum<2;
52: exception
53: when others then null;

Line 58: from qpr_time_allhier_v

54: end;
55: elsif p_low_lvl_time = 'YEAR' then
56: begin
57: select day into i_date
58: from qpr_time_allhier_v
59: where year = p_time_pk
60: and rownum<2;
61: exception
62: when others then null;

Line 67: from qpr_time_allhier_v

63: end;
64: elsif p_low_lvl_time = 'FISCAL_YEAR' then
65: begin
66: select day into i_date
67: from qpr_time_allhier_v
68: where fiscal_year = p_time_pk
69: and rownum<2;
70: exception
71: when others then null;