APPS.PAY_US_PAYROLL_UTILS dependencies on PAY_BAL_ATTRIBUTE_DEFINITIONS

Line 759: c_attribute_name in pay_bal_attribute_definitions.attribute_name%type)

755: ** Cursor to check if the attribute_name passed as parameter
756: ** exists or not.
757: **************************************************************/
758: CURSOR c_attribute_exists(
759: c_attribute_name in pay_bal_attribute_definitions.attribute_name%type)
760: is
761: select 1
762: from pay_bal_attribute_definitions
763: where attribute_name = c_attribute_name

Line 762: from pay_bal_attribute_definitions

758: CURSOR c_attribute_exists(
759: c_attribute_name in pay_bal_attribute_definitions.attribute_name%type)
760: is
761: select 1
762: from pay_bal_attribute_definitions
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,

Line 770: from pay_bal_attribute_definitions pbad,

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,
772: pay_balance_validation pbv
773: where pbad.attribute_name = cp_attribute_name
774: and pbad.attribute_id = pba.attribute_id

Line 788: from pay_bal_attribute_definitions pbad,

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,
789: pay_balance_attributes pba
790: where pbad.attribute_name = cp_attribute_name
791: and pbad.attribute_id = pba.attribute_id
792: and (pba.business_group_id = cp_business_group_id