APPS.PAY_EBRA_DIAGNOSTICS dependencies on PER_BUSINESS_GROUPS

Line 360: cp_business_group_id in per_business_groups.business_group_id%type,

356: ** exists or not.
357: **************************************************************/
358:
359: CURSOR c_get_valid_count(cp_start_date in date,
360: cp_business_group_id in per_business_groups.business_group_id%type,
361: cp_attribute_id in number) IS
362: select /*+ ORDERED */ count(*)
363: from
364: pay_balance_attributes pba,

Line 375: cp_business_group_id in per_business_groups.business_group_id%type) IS

371: and NVL(pbv.balance_load_date, cp_start_date) <= cp_start_date
372: and nvl(pbv.run_balance_status, 'I') = 'V';
373:
374: CURSOR c_get_attribute_count(cp_attribute_id in number,
375: cp_business_group_id in per_business_groups.business_group_id%type) IS
376:
377: select count(*)
378: from
379: pay_balance_attributes pba

Line 681: , per_business_groups pbg, hr_lookups hl

677: ,nvl(hl.meaning, hl2.meaning) Status
678: FROM
679: pay_defined_balances pdb, pay_balance_types pbt
680: , pay_balance_dimensions pbd
681: , per_business_groups pbg, hr_lookups hl
682: , pay_balance_validation pbv
683: , hr_lookups hl2
684: WHERE pdb.balance_type_id = pbt.balance_type_id
685: AND pdb.balance_dimension_id = pbd.balance_dimension_id