APPS.PQP_EXCP_RPT dependencies on PER_BUSINESS_GROUPS

Line 93: p_business_group_id per_business_groups.business_group_id%TYPE

89: --
90: -- Cursor to get the leg_code and the currency code
91: --
92: CURSOR c_get_codes(
93: p_business_group_id per_business_groups.business_group_id%TYPE
94: )
95: IS
96: SELECT Distinct legislation_code,currency_code
97: FROM per_business_groups

Line 97: FROM per_business_groups

93: p_business_group_id per_business_groups.business_group_id%TYPE
94: )
95: IS
96: SELECT Distinct legislation_code,currency_code
97: FROM per_business_groups
98: WHERE business_group_id =p_business_group_id;
99: -- End of cursor
100:
101:

Line 257: l_legislation_code per_business_groups.legislation_code%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);
260: l_variance_value pqp_exception_reports.variance_value%TYPE;
261: l_comparison_value pqp_exception_reports.comparison_value%TYPE;

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