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.PQP_EXCP_RPT dependencies on PQP_EXCEPTION_REPORTS

Line 107: p_report_id pqp_exception_reports.exception_report_id%TYPE,

103: -- Cursor to get the values for variance value, comparison value,
104: -- report name and output format
105: --
106: CURSOR c_get_values(
107: p_report_id pqp_exception_reports.exception_report_id%TYPE,
108: p_business_group_id pqp_exception_reports.business_group_id%TYPE,
109: p_legislation_code pqp_exception_reports.legislation_code%TYPE
110: )
111: IS

Line 108: p_business_group_id pqp_exception_reports.business_group_id%TYPE,

104: -- report name and output format
105: --
106: CURSOR c_get_values(
107: p_report_id pqp_exception_reports.exception_report_id%TYPE,
108: p_business_group_id pqp_exception_reports.business_group_id%TYPE,
109: p_legislation_code pqp_exception_reports.legislation_code%TYPE
110: )
111: IS
112: SELECT variance_value

Line 109: p_legislation_code pqp_exception_reports.legislation_code%TYPE

105: --
106: CURSOR c_get_values(
107: p_report_id pqp_exception_reports.exception_report_id%TYPE,
108: p_business_group_id pqp_exception_reports.business_group_id%TYPE,
109: p_legislation_code pqp_exception_reports.legislation_code%TYPE
110: )
111: IS
112: SELECT variance_value
113: ,comparison_value

Line 117: FROM pqp_exception_reports

113: ,comparison_value
114: ,exception_report_name
115: ,output_format
116: ,balance_dimension_id
117: FROM pqp_exception_reports
118: WHERE exception_report_id=p_report_id
119: AND (business_group_id IS NULL
120: OR business_group_id=p_business_group_id)
121: AND (legislation_code IS NULL

Line 130: p_report_id pqp_exception_reports.exception_report_id%TYPE,

126: --
127: -- Cursor to get the comparison type from look up
128: --
129: CURSOR c_get_comparison_type(
130: p_report_id pqp_exception_reports.exception_report_id%TYPE,
131: p_business_group_id pqp_exception_reports.business_group_id%TYPE,
132: p_legislation_code pqp_exception_reports.legislation_code%TYPE
133: )
134: IS

Line 131: p_business_group_id pqp_exception_reports.business_group_id%TYPE,

127: -- Cursor to get the comparison type from look up
128: --
129: CURSOR c_get_comparison_type(
130: p_report_id pqp_exception_reports.exception_report_id%TYPE,
131: p_business_group_id pqp_exception_reports.business_group_id%TYPE,
132: p_legislation_code pqp_exception_reports.legislation_code%TYPE
133: )
134: IS
135: SELECT meaning

Line 132: p_legislation_code pqp_exception_reports.legislation_code%TYPE

128: --
129: CURSOR c_get_comparison_type(
130: p_report_id pqp_exception_reports.exception_report_id%TYPE,
131: p_business_group_id pqp_exception_reports.business_group_id%TYPE,
132: p_legislation_code pqp_exception_reports.legislation_code%TYPE
133: )
134: IS
135: SELECT meaning
136: FROM hr_lookups

Line 140: FROM pqp_exception_reports

136: FROM hr_lookups
137: WHERE lookup_type='PQP_COMPARISON_TYPE'
138: AND lookup_code=(
139: SELECT comparison_type
140: FROM pqp_exception_reports
141: WHERE exception_report_id=p_report_id
142: AND (business_group_id IS NULL
143: OR business_group_id=p_business_group_id)
144: AND (legislation_code IS NULL

Line 152: p_report_id pqp_exception_reports.exception_report_id%TYPE,

148: --
149: -- Cursor to get the variance type from the lookup
150: --
151: CURSOR c_get_variance_type(
152: p_report_id pqp_exception_reports.exception_report_id%TYPE,
153: p_business_group_id pqp_exception_reports.business_group_id%TYPE,
154: p_legislation_code pqp_exception_reports.legislation_code%TYPE
155: )
156: IS

Line 153: p_business_group_id pqp_exception_reports.business_group_id%TYPE,

149: -- Cursor to get the variance type from the lookup
150: --
151: CURSOR c_get_variance_type(
152: p_report_id pqp_exception_reports.exception_report_id%TYPE,
153: p_business_group_id pqp_exception_reports.business_group_id%TYPE,
154: p_legislation_code pqp_exception_reports.legislation_code%TYPE
155: )
156: IS
157: SELECT distinct hrl.meaning

Line 154: p_legislation_code pqp_exception_reports.legislation_code%TYPE

150: --
151: CURSOR c_get_variance_type(
152: p_report_id pqp_exception_reports.exception_report_id%TYPE,
153: p_business_group_id pqp_exception_reports.business_group_id%TYPE,
154: p_legislation_code pqp_exception_reports.legislation_code%TYPE
155: )
156: IS
157: SELECT distinct hrl.meaning
158: FROM pqp_exception_reports per,

Line 158: FROM pqp_exception_reports per,

154: p_legislation_code pqp_exception_reports.legislation_code%TYPE
155: )
156: IS
157: SELECT distinct hrl.meaning
158: FROM pqp_exception_reports per,
159: hr_lookups hrl
160: WHERE per.exception_report_id=p_report_id
161: AND (per.business_group_id IS NULL
162: OR per.business_group_id=p_business_group_id)

Line 173: p_report_id pqp_exception_reports.exception_report_id%TYPE,

169: --
170: -- Cursor to get the variance operator from the look up
171: --
172: CURSOR c_get_variance_operator(
173: p_report_id pqp_exception_reports.exception_report_id%TYPE,
174: p_business_group_id pqp_exception_reports.business_group_id%TYPE,
175: p_legislation_code pqp_exception_reports.legislation_code%TYPE
176: )
177: IS

Line 174: p_business_group_id pqp_exception_reports.business_group_id%TYPE,

170: -- Cursor to get the variance operator from the look up
171: --
172: CURSOR c_get_variance_operator(
173: p_report_id pqp_exception_reports.exception_report_id%TYPE,
174: p_business_group_id pqp_exception_reports.business_group_id%TYPE,
175: p_legislation_code pqp_exception_reports.legislation_code%TYPE
176: )
177: IS
178: SELECT meaning

Line 175: p_legislation_code pqp_exception_reports.legislation_code%TYPE

171: --
172: CURSOR c_get_variance_operator(
173: p_report_id pqp_exception_reports.exception_report_id%TYPE,
174: p_business_group_id pqp_exception_reports.business_group_id%TYPE,
175: p_legislation_code pqp_exception_reports.legislation_code%TYPE
176: )
177: IS
178: SELECT meaning
179: FROM HR_LOOKUPS HRL

Line 184: FROM pqp_exception_reports

180: WHERE HRL.LOOKUP_TYPE = 'PQP_OPERATOR_TYPES'
181: AND HRL.ENABLED_FLAG = 'Y'
182: AND LOOKUP_CODE =(
183: SELECT distinct variance_operator
184: FROM pqp_exception_reports
185: WHERE exception_report_id=p_report_id
186: AND (business_group_id IS NULL
187: OR business_group_id=p_business_group_id)
188: AND (legislation_code IS NULL

Line 227: FROM pqp_exception_reports

223: --
224: CURSOR c_get_output_format
225: IS
226: SELECT output_format
227: FROM pqp_exception_reports
228: WHERE exception_report_name = p_report_name
229: AND (business_group_id= p_business_group_id
230: OR business_group_id IS NULL)
231: UNION

Line 246: l_business_group_id_old pqp_exception_reports.business_group_id%TYPE;

242: --
243: l_payroll_id_old pay_payrolls_f.payroll_id%TYPE;
244: l_consolidation_set_id_old pay_consolidation_sets.consolidation_set_id%TYPE;
245: l_balance_type_id_old pay_balance_types.balance_type_id%TYPE;
246: l_business_group_id_old pqp_exception_reports.business_group_id%TYPE;
247: l_report_id_old pqp_exception_reports.exception_report_id%TYPE;
248:
249: --
250: -- Local Variables

Line 247: l_report_id_old pqp_exception_reports.exception_report_id%TYPE;

243: l_payroll_id_old pay_payrolls_f.payroll_id%TYPE;
244: l_consolidation_set_id_old pay_consolidation_sets.consolidation_set_id%TYPE;
245: l_balance_type_id_old pay_balance_types.balance_type_id%TYPE;
246: l_business_group_id_old pqp_exception_reports.business_group_id%TYPE;
247: l_report_id_old pqp_exception_reports.exception_report_id%TYPE;
248:
249: --
250: -- Local Variables
251: --

Line 255: l_dimension_id pqp_exception_reports.balance_dimension_id%TYPE;

251: --
252: l_payroll_name pay_payrolls_f.payroll_name%TYPE;
253: l_consolidation_set_name pay_consolidation_sets.consolidation_set_name%TYPE;
254: l_balance_name pay_balance_types.balance_name%TYPE;
255: l_dimension_id pqp_exception_reports.balance_dimension_id%TYPE;
256: l_dimension_name pay_balance_dimensions.dimension_name%TYPE;
257: l_legislation_code per_business_groups.legislation_code%TYPE;
258: l_currency_code per_business_groups.currency_code%TYPE;
259: l_currency_format varchar2(40);

Line 260: l_variance_value pqp_exception_reports.variance_value%TYPE;

256: l_dimension_name pay_balance_dimensions.dimension_name%TYPE;
257: l_legislation_code per_business_groups.legislation_code%TYPE;
258: l_currency_code per_business_groups.currency_code%TYPE;
259: l_currency_format varchar2(40);
260: l_variance_value pqp_exception_reports.variance_value%TYPE;
261: l_comparison_value pqp_exception_reports.comparison_value%TYPE;
262: l_exception_report_name pqp_exception_reports.exception_report_name%TYPE;
263: l_exception_group_name pqp_exception_report_groups.exception_group_name%TYPE;
264: l_output_format pqp_exception_reports.output_format%TYPE;

Line 261: l_comparison_value pqp_exception_reports.comparison_value%TYPE;

257: l_legislation_code per_business_groups.legislation_code%TYPE;
258: l_currency_code per_business_groups.currency_code%TYPE;
259: l_currency_format varchar2(40);
260: l_variance_value pqp_exception_reports.variance_value%TYPE;
261: l_comparison_value pqp_exception_reports.comparison_value%TYPE;
262: l_exception_report_name pqp_exception_reports.exception_report_name%TYPE;
263: l_exception_group_name pqp_exception_report_groups.exception_group_name%TYPE;
264: l_output_format pqp_exception_reports.output_format%TYPE;
265: l_comparison_type varchar2(80);

Line 262: l_exception_report_name pqp_exception_reports.exception_report_name%TYPE;

258: l_currency_code per_business_groups.currency_code%TYPE;
259: l_currency_format varchar2(40);
260: l_variance_value pqp_exception_reports.variance_value%TYPE;
261: l_comparison_value pqp_exception_reports.comparison_value%TYPE;
262: l_exception_report_name pqp_exception_reports.exception_report_name%TYPE;
263: l_exception_group_name pqp_exception_report_groups.exception_group_name%TYPE;
264: l_output_format pqp_exception_reports.output_format%TYPE;
265: l_comparison_type varchar2(80);
266: l_variance_type pqp_exception_reports.variance_type%TYPE;

Line 264: l_output_format pqp_exception_reports.output_format%TYPE;

260: l_variance_value pqp_exception_reports.variance_value%TYPE;
261: l_comparison_value pqp_exception_reports.comparison_value%TYPE;
262: l_exception_report_name pqp_exception_reports.exception_report_name%TYPE;
263: l_exception_group_name pqp_exception_report_groups.exception_group_name%TYPE;
264: l_output_format pqp_exception_reports.output_format%TYPE;
265: l_comparison_type varchar2(80);
266: l_variance_type pqp_exception_reports.variance_type%TYPE;
267: l_variance_operator varchar2(80);
268: l_business_group_name varchar2(80);

Line 266: l_variance_type pqp_exception_reports.variance_type%TYPE;

262: l_exception_report_name pqp_exception_reports.exception_report_name%TYPE;
263: l_exception_group_name pqp_exception_report_groups.exception_group_name%TYPE;
264: l_output_format pqp_exception_reports.output_format%TYPE;
265: l_comparison_type varchar2(80);
266: l_variance_type pqp_exception_reports.variance_type%TYPE;
267: l_variance_operator varchar2(80);
268: l_business_group_name varchar2(80);
269: l_variance varchar2(100);
270: l_full_name per_all_people_f.full_name%TYPE;