APPS.PAY_NL_SOE dependencies on PAY_BALANCE_TYPES

Line 371: TYPE balance_type_lst_rec is RECORD (balance_name pay_balance_types.balance_name%TYPE

367: ------------------------------------------------------------------------ */
368: function getBalances(p_assignment_action_id number
369: ,p_balance_attribute varchar2) return long is
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

Line 372: ,balance_type_id pay_balance_types.balance_type_id%TYPE

368: function getBalances(p_assignment_action_id number
369: ,p_balance_attribute varchar2) return long is
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);

Line 373: ,reporting_name pay_balance_types.reporting_name%TYPE

369: ,p_balance_attribute varchar2) return long is
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

Line 375: ,defined_balance_name pay_balance_types.reporting_name%TYPE

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;
379: l_balance_type_lst balance_type_lst_tab;

Line 452: , pay_balance_types_tl bt

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
456: OR bad.BUSINESS_GROUP_ID = l_business_group_id)