APPS.PAY_AU_PAYSUM_ALLOWANCE dependencies on PAY_BAL_ATTRIBUTE_DEFINITIONS

Line 53: pay_bal_attribute_definitions pbad

49: and pdb.balance_dimension_id(+) = c_balance_dimension_id
50: and not exists (
51: select null
52: from pay_balance_attributes pba,
53: pay_bal_attribute_definitions pbad
54: where pba.defined_balance_id = pdb.defined_balance_id
55: and pbad.attribute_name = 'AU_EOY_ALLOWANCE'
56: and pbad.attribute_id = pba.attribute_id
57: )

Line 83: from PAY_BAL_ATTRIBUTE_DEFINITIONS pbad

79:
80: CURSOR get_allowance_balance_lst (c_business_group_id in HR_ALL_ORGANIZATION_UNITS.organization_id%type)
81: IS
82: select pbt.balance_name, pbt.balance_type_id
83: from PAY_BAL_ATTRIBUTE_DEFINITIONS pbad
84: ,pay_balance_attributes pba
85: ,pay_defined_balances pdb
86: ,pay_balance_types pbt
87: ,pay_balance_dimensions pbd

Line 293: from PAY_BAL_ATTRIBUTE_DEFINITIONS

289: ) is
290:
291: CURSOR get_balance_attribute IS
292: select attribute_id
293: from PAY_BAL_ATTRIBUTE_DEFINITIONS
294: where attribute_name = 'AU_EOY_ALLOWANCE' ;
295:
296: l_attribute_id PAY_BAL_ATTRIBUTE_DEFINITIONS.attribute_id%type;
297: l_validate boolean;

Line 296: l_attribute_id PAY_BAL_ATTRIBUTE_DEFINITIONS.attribute_id%type;

292: select attribute_id
293: from PAY_BAL_ATTRIBUTE_DEFINITIONS
294: where attribute_name = 'AU_EOY_ALLOWANCE' ;
295:
296: l_attribute_id PAY_BAL_ATTRIBUTE_DEFINITIONS.attribute_id%type;
297: l_validate boolean;
298: l_balance_attribute_id PAY_BALANCE_ATTRIBUTES.balance_attribute_id%type;
299: e_bad_global exception;
300: