APPS.PQP_EXCP_RPT dependencies on PAY_BALANCE_TYPES

Line 82: p_balance_type_id pay_balance_types.balance_type_id%TYPE

78: --
79: -- Cursor to get the balance name
80: --
81: CURSOR c_get_balance_name(
82: p_balance_type_id pay_balance_types.balance_type_id%TYPE
83: )
84: IS
85: SELECT DISTINCT balance_name
86: FROM pay_balance_types

Line 86: FROM pay_balance_types

82: p_balance_type_id pay_balance_types.balance_type_id%TYPE
83: )
84: IS
85: SELECT DISTINCT balance_name
86: FROM pay_balance_types
87: WHERE balance_type_id=p_balance_type_id;
88:
89: --
90: -- Cursor to get the leg_code and the currency code

Line 245: l_balance_type_id_old pay_balance_types.balance_type_id%TYPE;

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:
249: --

Line 254: l_balance_name pay_balance_types.balance_name%TYPE;

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;
258: l_currency_code per_business_groups.currency_code%TYPE;