DBA Data[Home] [Help]

APPS.PAY_NL_SOE dependencies on PAY_BALANCE_DIMENSIONS

Line 374: ,dimension_name pay_balance_dimensions.dimension_name%TYPE

370: --
371: TYPE balance_type_lst_rec is RECORD (balance_name pay_balance_types.balance_name%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;

Line 451: , pay_balance_dimensions bd

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
455: and ( bad.BUSINESS_GROUP_ID IS NULL