APPS.HZ_DNBUI_PVT dependencies on HZ_FINANCIAL_NUMBERS

Line 56: | 17-OCT-00 Jianying Huang Bug 1462704: Rename table HZ_FINANCIAL_NUMBERS to

52: |
53: | RETURNS : NONE
54: |
55: | MODIFICATION HISTORY
56: | 17-OCT-00 Jianying Huang Bug 1462704: Rename table HZ_FINANCIAL_NUMBERS to
57: | HZ_FINANCIAL_NUMBERS_R1
58: | 30-OCT-00 Jianying Huang Roll back the renaming table changes.
59: |
60: +======================================================================*/

Line 57: | HZ_FINANCIAL_NUMBERS_R1

53: | RETURNS : NONE
54: |
55: | MODIFICATION HISTORY
56: | 17-OCT-00 Jianying Huang Bug 1462704: Rename table HZ_FINANCIAL_NUMBERS to
57: | HZ_FINANCIAL_NUMBERS_R1
58: | 30-OCT-00 Jianying Huang Roll back the renaming table changes.
59: |
60: +======================================================================*/
61:

Line 68: select financial_number into v_financial_number from hz_financial_numbers

64: v_financial_number NUMBER;
65:
66: BEGIN
67:
68: select financial_number into v_financial_number from hz_financial_numbers
69: where financial_report_id = p_financial_report_id
70: and financial_number_name = p_financial_name;
71:
72: RETURN v_financial_number;

Line 90: | 17-OCT-00 Jianying Huang Bug 1462704: Rename table HZ_FINANCIAL_NUMBERS to

86: |
87: | RETURNS : NONE
88: |
89: | MODIFICATION HISTORY
90: | 17-OCT-00 Jianying Huang Bug 1462704: Rename table HZ_FINANCIAL_NUMBERS to
91: | HZ_FINANCIAL_NUMBERS_R1
92: | 30-OCT-00 Jianying Huang Roll back the renaming table changes.
93: |
94: +======================================================================*/

Line 91: | HZ_FINANCIAL_NUMBERS_R1

87: | RETURNS : NONE
88: |
89: | MODIFICATION HISTORY
90: | 17-OCT-00 Jianying Huang Bug 1462704: Rename table HZ_FINANCIAL_NUMBERS to
91: | HZ_FINANCIAL_NUMBERS_R1
92: | 30-OCT-00 Jianying Huang Roll back the renaming table changes.
93: |
94: +======================================================================*/
95:

Line 102: select financial_number_currency into v_financial_number_currency from hz_financial_numbers

98: v_financial_number_currency VARCHAR2(240);
99:
100: BEGIN
101:
102: select financial_number_currency into v_financial_number_currency from hz_financial_numbers
103: where financial_report_id = p_financial_report_id
104: and financial_number_name = p_financial_name;
105:
106: RETURN v_financial_number_currency;

Line 125: | 17-OCT-00 Jianying HUang Bug 1462704: Rename table HZ_FINANCIAL_NUMBERS to

121: |
122: | RETURNS : NONE
123: |
124: | MODIFICATION HISTORY
125: | 17-OCT-00 Jianying HUang Bug 1462704: Rename table HZ_FINANCIAL_NUMBERS to
126: | HZ_FINANCIAL_NUMBERS_R1
127: | 30-OCT-00 Jianying Huang Roll back the renaming table changes.
128: |
129: +======================================================================*/

Line 126: | HZ_FINANCIAL_NUMBERS_R1

122: | RETURNS : NONE
123: |
124: | MODIFICATION HISTORY
125: | 17-OCT-00 Jianying HUang Bug 1462704: Rename table HZ_FINANCIAL_NUMBERS to
126: | HZ_FINANCIAL_NUMBERS_R1
127: | 30-OCT-00 Jianying Huang Roll back the renaming table changes.
128: |
129: +======================================================================*/
130:

Line 137: select projected_actual_flag into v_financial_number_actflg from hz_financial_numbers

133: v_financial_number_actflg VARCHAR2(240);
134:
135: BEGIN
136:
137: select projected_actual_flag into v_financial_number_actflg from hz_financial_numbers
138: where financial_report_id = p_financial_report_id
139: and financial_number_name = p_financial_name;
140:
141: RETURN v_financial_number_actflg;