APPS.PAY_IP_EMPLOYEE_BALANCES dependencies on PAY_DEFINED_BALANCES

Line 446: FROM pay_defined_balances pdb_call,

442: pdb_call.defined_balance_id,
443: pbt.balance_type_id,
444: pbd.balance_dimension_id,
445: pbd.database_item_suffix
446: FROM pay_defined_balances pdb_call,
447: pay_balance_dimensions pbd,
448: pay_balance_types pbt,
449: pay_element_types_f pet
450: WHERE pbt.balance_type_id = fnd_number.canonical_to_number(p_balance_type_id)

Line 474: FROM pay_defined_balances pdb_call,

470: pdb_call.defined_balance_id,
471: pbt.balance_type_id,
472: pbd.balance_dimension_id,
473: pbd.database_item_suffix
474: FROM pay_defined_balances pdb_call,
475: pay_balance_dimensions pbd,
476: pay_balance_types pbt,
477: pay_element_types_f pet
478: WHERE pbt.balance_type_id = fnd_number.canonical_to_number(p_balance_type_id)

Line 501: FROM pay_defined_balances pdb_call,

497: pet.element_type_id,
498: pdb_call.defined_balance_id,
499: pbt.balance_type_id,
500: pbd.balance_dimension_id
501: FROM pay_defined_balances pdb_call,
502: pay_balance_dimensions pbd,
503: pay_balance_types pbt,
504: pay_element_types_f pet
505: WHERE pbt.balance_type_id = fnd_number.canonical_to_number(p_balance_type_id)

Line 527: FROM pay_defined_balances pdb_call,

523: pet.element_type_id,
524: pdb_call.defined_balance_id,
525: pbt.balance_type_id,
526: pbd.balance_dimension_id
527: FROM pay_defined_balances pdb_call,
528: pay_balance_dimensions pbd,
529: pay_balance_types pbt,
530: pay_element_types_f pet
531: WHERE pbt.balance_type_id = fnd_number.canonical_to_number(p_balance_type_id)

Line 767: FROM pay_defined_balances

763: WHERE database_item_suffix = p_dimension
764: AND legislation_code = l_legislation_code;
765:
766: SELECT defined_balance_id INTO l_defbal_id
767: FROM pay_defined_balances
768: WHERE balance_type_id = p_bal_id
769: AND balance_dimension_id = l_dim_id
770: AND nvl(business_group_id,p_business_group_id) = p_business_group_id
771: AND nvl(legislation_code,l_legislation_code) = l_legislation_code;