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 PAY_CONSOLIDATION_SETS

Line 67: p_consolidation_set_id pay_consolidation_sets.consolidation_set_id%TYPE,

63: --
64: -- Cursor to get the consolidation set name
65: --
66: CURSOR c_get_consolidation_set_name(
67: p_consolidation_set_id pay_consolidation_sets.consolidation_set_id%TYPE,
68: p_business_group_id pay_consolidation_sets.business_group_id%TYPE
69: )
70: IS
71: SELECT consolidation_set_name

Line 68: p_business_group_id pay_consolidation_sets.business_group_id%TYPE

64: -- Cursor to get the consolidation set name
65: --
66: CURSOR c_get_consolidation_set_name(
67: p_consolidation_set_id pay_consolidation_sets.consolidation_set_id%TYPE,
68: p_business_group_id pay_consolidation_sets.business_group_id%TYPE
69: )
70: IS
71: SELECT consolidation_set_name
72: from pay_consolidation_sets

Line 72: from pay_consolidation_sets

68: p_business_group_id pay_consolidation_sets.business_group_id%TYPE
69: )
70: IS
71: SELECT consolidation_set_name
72: from pay_consolidation_sets
73: WHERE consolidation_set_id=p_consolidation_set_id
74: AND (business_group_id =p_business_group_id
75: OR business_group_id IS NULL);
76: -- End of cursor

Line 244: l_consolidation_set_id_old pay_consolidation_sets.consolidation_set_id%TYPE;

240: --
241: -- Variables used to keep backup (old/Previous) values
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:

Line 253: l_consolidation_set_name pay_consolidation_sets.consolidation_set_name%TYPE;

249: --
250: -- Local Variables
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;