APPS.PAY_US_PAYROLL_UTILS dependencies on PAY_BAL_ATTRIBUTE_DEFINITIONS

Line 745: c_attribute_name in pay_bal_attribute_definitions.attribute_name%type)

741: ** Cursor to check if the attribute_name passed as parameter
742: ** exists or not.
743: **************************************************************/
744: CURSOR c_attribute_exists(
745: c_attribute_name in pay_bal_attribute_definitions.attribute_name%type)
746: is
747: select 1
748: from pay_bal_attribute_definitions
749: where attribute_name = c_attribute_name

Line 748: from pay_bal_attribute_definitions

744: CURSOR c_attribute_exists(
745: c_attribute_name in pay_bal_attribute_definitions.attribute_name%type)
746: is
747: select 1
748: from pay_bal_attribute_definitions
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,

Line 756: from pay_bal_attribute_definitions pbad,

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,
758: pay_balance_validation pbv
759: where pbad.attribute_name = cp_attribute_name
760: and pbad.attribute_id = pba.attribute_id

Line 774: from pay_bal_attribute_definitions pbad,

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,
775: pay_balance_attributes pba
776: where pbad.attribute_name = cp_attribute_name
777: and pbad.attribute_id = pba.attribute_id
778: and (pba.business_group_id = cp_business_group_id