DBA Data[Home] [Help]

APPS.PAY_NL_SOE dependencies on PAY_DEFINED_BALANCES

Line 376: ,defined_balance_id pay_defined_balances.defined_balance_id%TYPE);

372: ,balance_type_id pay_balance_types.balance_type_id%TYPE
373: ,reporting_name pay_balance_types.reporting_name%TYPE
374: ,dimension_name pay_balance_dimensions.dimension_name%TYPE
375: ,defined_balance_name pay_balance_types.reporting_name%TYPE
376: ,defined_balance_id pay_defined_balances.defined_balance_id%TYPE);
377: TYPE balance_type_lst_tab is TABLE of balance_type_lst_rec
378: INDEX BY BINARY_INTEGER;
379: l_balance_type_lst balance_type_lst_tab;
380: --

Line 450: , pay_defined_balances db

446: , bt.balance_type_id
447: , NVL(NVL(oi.org_information7,bt.reporting_name),bt.balance_name) defined_balance_name
448: from pay_balance_attributes ba
449: , pay_bal_attribute_definitions bad
450: , pay_defined_balances db
451: , pay_balance_dimensions bd
452: , pay_balance_types_tl bt
453: , hr_organization_information oi
454: where bad.attribute_name = p_balance_attribute