DBA Data[Home] [Help]

APPS.PAY_MX_UTILITY dependencies on PAY_BALANCE_TYPES

Line 25: from pay_balance_types pbt,

21: RETURN NUMBER IS
22:
23: cursor c_days_bal_type_id (cp_balance_type_id NUMBER) is
24: select pbt.balance_type_id, pbt.balance_uom
25: from pay_balance_types pbt,
26: pay_defined_balances pdb,
27: pay_balance_attributes pba,
28: pay_bal_attribute_definitions pbad
29: where pbad.attribute_name = 'Earnings Days'

Line 107: from pay_balance_types pbt,

103: RETURN NUMBER IS
104:
105: cursor c_hours_bal_type_id (cp_balance_type_id NUMBER) is
106: select pbt.balance_type_id, pbt.balance_uom
107: from pay_balance_types pbt,
108: pay_defined_balances pdb,
109: pay_balance_attributes pba,
110: pay_bal_attribute_definitions pbad
111: where pbad.attribute_name = 'Earnings Hours'