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_BALANCE_DIMENSIONS

Line 584: l_balance_dimension_id PAY_BALANCE_DIMENSIONS.BALANCE_DIMENSION_ID%TYPE;

580: l_bal_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_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;

Line 630: from pay_balance_dimensions

626: cursor csr_sel_bal_dim_id(p_DIMENSION_NAME VARCHAR2,
627: p_LEGISLATION_CODE VARCHAR2,
628: p_bg_id NUMBER) is
629: select balance_dimension_id
630: from pay_balance_dimensions
631: where dimension_name =p_DIMENSION_NAME
632: AND nvl(legislation_code,1) =nvl(p_LEGISLATION_CODE,1)
633: and (business_group_id =p_bg_id or business_group_id is null);
634:

Line 794: l_balance_dimension_id PAY_BALANCE_DIMENSIONS.BALANCE_DIMENSION_ID%TYPE;

790: PAY_BAL_ATTRIBUTE_DEFAULTS.BAL_ATTRIBUTE_DEFAULT_ID%TYPE;
791: l_balance_category_id PAY_BALANCE_CATEGORIES_F.BALANCE_CATEGORY_ID%TYPE;
792: l_legislation_code PAY_BAL_ATTRIBUTE_DEFAULTS.LEGISLATION_CODE%TYPE;
793: l_attribute_id PAY_BAL_ATTRIBUTE_DEFINITIONS.ATTRIBUTE_ID%TYPE;
794: l_balance_dimension_id PAY_BALANCE_DIMENSIONS.BALANCE_DIMENSION_ID%TYPE;
795: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;
796: l_attr_bus_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;
797: l_cat_bus_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;
798: l_dim_bus_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;

Line 808: from pay_balance_dimensions

804: cursor csr_sel_bal_dim_id(p_DIMENSION_NAME VARCHAR2,
805: p_LEGISLATION_CODE VARCHAR2,
806: p_bg_id NUMBER) is
807: select balance_dimension_id
808: from pay_balance_dimensions
809: where dimension_name=p_DIMENSION_NAME
810: AND nvl(legislation_code,1) =nvl(p_LEGISLATION_CODE,1)
811: and (business_group_id =p_bg_id or business_group_id is null);
812: