DBA Data[Home] [Help]

APPS.PAY_US_PAYROLL_UTILS dependencies on PER_BUSINESS_GROUPS

Line 753: cp_business_group_id in per_business_groups.business_group_id%type,

749: where attribute_name = c_attribute_name
750: and legislation_code = p_legislation_code;
751:
752: CURSOR c_get_valid_count(cp_start_date in date,
753: cp_business_group_id in per_business_groups.business_group_id%type,
754: cp_attribute_name in varchar2) IS
755: select /*+ ORDERED */ count(*)
756: from pay_bal_attribute_definitions pbad,
757: pay_balance_attributes pba,

Line 770: cp_business_group_id in per_business_groups.business_group_id%type,

766: and NVL(pbv.balance_load_date, cp_start_date) <= cp_start_date
767: and nvl(pbv.run_balance_status, 'I') = 'V';
768:
769: CURSOR c_get_attribute_count(
770: cp_business_group_id in per_business_groups.business_group_id%type,
771: cp_attribute_name in varchar2) IS
772:
773: select count(*)
774: from pay_bal_attribute_definitions pbad,