eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_BALANCES_UPLOAD_PKG dependencies on PAY_DEFINED_BALANCES

Line 585: l_defined_balance_id PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;

581: l_attr_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;
582: l_attribute_id PAY_BALANCE_ATTRIBUTES.ATTRIBUTE_ID%TYPE;
583: l_balance_type_id PAY_BALANCE_TYPES.BALANCE_TYPE_ID%TYPE;
584: l_balance_dimension_id PAY_BALANCE_DIMENSIONS.BALANCE_DIMENSION_ID%TYPE;
585: l_defined_balance_id PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;
586: l_legislation_code PAY_BALANCE_ATTRIBUTES.LEGISLATION_CODE%TYPE;
587: l_def_bal_leg_code PAY_DEFINED_BALANCES.LEGISLATION_CODE%TYPE;
588: l_def_bal_bg_id PAY_DEFINED_BALANCES.BUSINESS_GROUP_ID%TYPE;
589: l_owner VARCHAR2(6);

Line 587: l_def_bal_leg_code PAY_DEFINED_BALANCES.LEGISLATION_CODE%TYPE;

583: l_balance_type_id PAY_BALANCE_TYPES.BALANCE_TYPE_ID%TYPE;
584: l_balance_dimension_id PAY_BALANCE_DIMENSIONS.BALANCE_DIMENSION_ID%TYPE;
585: l_defined_balance_id PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;
586: l_legislation_code PAY_BALANCE_ATTRIBUTES.LEGISLATION_CODE%TYPE;
587: l_def_bal_leg_code PAY_DEFINED_BALANCES.LEGISLATION_CODE%TYPE;
588: l_def_bal_bg_id PAY_DEFINED_BALANCES.BUSINESS_GROUP_ID%TYPE;
589: l_owner VARCHAR2(6);
590: l_session_id HR_OWNER_DEFINITIONS.SESSION_ID%TYPE;
591: l_session_id1 HR_OWNER_DEFINITIONS.SESSION_ID%TYPE;

Line 588: l_def_bal_bg_id PAY_DEFINED_BALANCES.BUSINESS_GROUP_ID%TYPE;

584: l_balance_dimension_id PAY_BALANCE_DIMENSIONS.BALANCE_DIMENSION_ID%TYPE;
585: l_defined_balance_id PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;
586: l_legislation_code PAY_BALANCE_ATTRIBUTES.LEGISLATION_CODE%TYPE;
587: l_def_bal_leg_code PAY_DEFINED_BALANCES.LEGISLATION_CODE%TYPE;
588: l_def_bal_bg_id PAY_DEFINED_BALANCES.BUSINESS_GROUP_ID%TYPE;
589: l_owner VARCHAR2(6);
590: l_session_id HR_OWNER_DEFINITIONS.SESSION_ID%TYPE;
591: l_session_id1 HR_OWNER_DEFINITIONS.SESSION_ID%TYPE;
592:

Line 609: from pay_defined_balances

605: p_balance_dimension_id NUMBER,
606: p_LEGISLATION_CODE VARCHAR2,
607: p_bg_id NUMBER)is
608: select defined_balance_id
609: from pay_defined_balances
610: where balance_type_id =p_balance_type_id
611: and balance_dimension_id =p_balance_dimension_id
612: AND nvl(legislation_code,1) =nvl(p_LEGISLATION_CODE,1)
613: and (business_group_id =p_bg_id or business_group_id is null);