DBA Data[Home] [Help]

APPS.PAY_US_PAYROLL_UTILS dependencies on PER_BUSINESS_GROUPS

Line 767: cp_business_group_id in per_business_groups.business_group_id%type,

763: where attribute_name = c_attribute_name
764: and legislation_code = p_legislation_code;
765:
766: CURSOR c_get_valid_count(cp_start_date in date,
767: cp_business_group_id in per_business_groups.business_group_id%type,
768: cp_attribute_name in varchar2) IS
769: select /*+ ORDERED */ count(*)
770: from pay_bal_attribute_definitions pbad,
771: pay_balance_attributes pba,

Line 784: cp_business_group_id in per_business_groups.business_group_id%type,

780: and NVL(pbv.balance_load_date, cp_start_date) <= cp_start_date
781: and nvl(pbv.run_balance_status, 'I') = 'V';
782:
783: CURSOR c_get_attribute_count(
784: cp_business_group_id in per_business_groups.business_group_id%type,
785: cp_attribute_name in varchar2) IS
786:
787: select count(*)
788: from pay_bal_attribute_definitions pbad,