APPS.PAY_US_EMPLOYEE_BALANCES dependencies on PAY_DEFINED_BALANCES

Line 246: , pay_defined_balances pdb

242: p_business_group_id ,--ctlglobals.bg_id
243: NULL) YTD_VAL
244: from pay_element_types_f pet
245: , pay_element_classifications pec
246: , pay_defined_balances pdb
247: , pay_bal_attribute_definitions pbad
248: , pay_balance_attributes pba
249: , pay_balance_types pbt
250: , pay_assignment_actions paa

Line 270: pay_defined_balances pdb

266: AND pet.element_name not like 'VERTEX%'
267: and pet.element_information10= pDB.balance_type_id
268: AND EXISTS (select prb.balance_value
269: from pay_run_balances prb,
270: pay_defined_balances pdb
271: where prb.defined_balance_id = pdb.defined_balance_id
272: and prb.assignment_id = paa.assignment_id
273: and pdb.balance_type_id = pet.element_information10
274: and rownum < 2)

Line 332: , pay_defined_balances pdb

328: p_business_group_id ,--ctlglobals.bg_id
329: NULL) YTD_VAL
330: from pay_element_types_f pet
331: , pay_element_classifications pec
332: , pay_defined_balances pdb
333: , pay_bal_attribute_definitions pbad
334: , pay_balance_attributes pba
335: , pay_balance_types pbt
336: , pay_assignment_actions paa

Line 356: pay_defined_balances pdb

352: AND pet.element_name not like 'VERTEX%'
353: and pet.element_information10= pDB.balance_type_id
354: AND EXISTS (select prb.balance_value
355: from pay_run_balances prb,
356: pay_defined_balances pdb
357: where prb.defined_balance_id = pdb.defined_balance_id
358: and prb.assignment_id = paa.assignment_id
359: and pdb.balance_type_id in (pet.element_information10
360: ,pet.element_information11

Line 579: FROM pay_defined_balances

575: hr_utility.set_location(l_package||l_function, 10);
576:
577: SELECT defined_balance_id
578: INTO v_defbal_id
579: FROM pay_defined_balances
580: WHERE balance_type_id = p_bal_id
581: AND balance_dimension_id = p_dim_id
582: AND nvl(business_group_id,p_business_group_id) = p_business_group_id
583: AND nvl(legislation_code,p_legislation_code) = p_legislation_code;