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_ATTRIBUTES

Line 423: from pay_balance_attributes

419: --cursors to check if child rows exist
420: cursor csr_pba_id(p_attrib_id PAY_BAL_ATTRIBUTE_DEFINITIONS.ATTRIBUTE_ID%TYPE)
421: is
422: select attribute_id
423: from pay_balance_attributes
424: where attribute_id=p_attrib_id;
425:
426: cursor csr_pbad_id(p_attrib_id PAY_BAL_ATTRIBUTE_DEFINITIONS.ATTRIBUTE_ID%TYPE)
427: is

Line 561: --This procedure is used for loading data into table PAY_BALANCE_ATTRIBUTES

557:
558: END PAY_BAL_ADE_LOAD_ROW;
559:
560:
561: --This procedure is used for loading data into table PAY_BALANCE_ATTRIBUTES
562: --This procedure is called from pybalatt.lct configuration file
563: PROCEDURE PAY_BAL_ATT_LOAD_ROW
564: (p_ATTRIBUTE_NAME IN VARCHAR2
565: ,p_ATTR_DEFN_LEG_CODE IN VARCHAR2

Line 578: l_balance_attribute_id PAY_BALANCE_ATTRIBUTES.BALANCE_ATTRIBUTE_ID%TYPE;

574: ,p_DIM_BUS_GROUP_NAME IN VARCHAR2
575: ,p_OWNER IN VARCHAR2
576: )IS
577:
578: l_balance_attribute_id PAY_BALANCE_ATTRIBUTES.BALANCE_ATTRIBUTE_ID%TYPE;
579: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_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;

Line 582: l_attribute_id PAY_BALANCE_ATTRIBUTES.ATTRIBUTE_ID%TYPE;

578: l_balance_attribute_id PAY_BALANCE_ATTRIBUTES.BALANCE_ATTRIBUTE_ID%TYPE;
579: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_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;

Line 586: l_legislation_code PAY_BALANCE_ATTRIBUTES.LEGISLATION_CODE%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);
590: l_session_id HR_OWNER_DEFINITIONS.SESSION_ID%TYPE;

Line 731: FROM PAY_BALANCE_ATTRIBUTES

727: l_attribute_id,
728: l_defined_balance_id,
729: l_legislation_code,
730: l_owner
731: FROM PAY_BALANCE_ATTRIBUTES
732: WHERE attribute_id = l_attribute_id
733: AND defined_balance_id = l_defined_balance_id
734: AND (business_group_id =l_business_group_id
735: OR business_group_id is null);