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 PER_BUSINESS_GROUPS

Line 9: from per_business_groups

5:
6: --Cursor to select business group id
7: cursor csr_bg_id(p_BG_NAME VARCHAR2) is
8: select business_group_id
9: from per_business_groups
10: where name =p_BG_NAME;
11:
12: --Cursor to determine if session id is present in hr_owner_definitions
13: CURSOR csr_get_session_id IS

Line 579: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;

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;
583: l_balance_type_id PAY_BALANCE_TYPES.BALANCE_TYPE_ID%TYPE;

Line 580: l_bal_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;

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;
583: l_balance_type_id PAY_BALANCE_TYPES.BALANCE_TYPE_ID%TYPE;
584: l_balance_dimension_id PAY_BALANCE_DIMENSIONS.BALANCE_DIMENSION_ID%TYPE;

Line 581: l_attr_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;

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;
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;

Line 795: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_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;
799: l_owner VARCHAR2(6);

Line 796: l_attr_bus_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_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;
799: l_owner VARCHAR2(6);
800: l_session_id HR_OWNER_DEFINITIONS.SESSION_ID%TYPE;

Line 797: l_cat_bus_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%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;
799: l_owner VARCHAR2(6);
800: l_session_id HR_OWNER_DEFINITIONS.SESSION_ID%TYPE;
801: l_session_id1 HR_OWNER_DEFINITIONS.SESSION_ID%TYPE;

Line 798: l_dim_bus_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_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;
799: l_owner VARCHAR2(6);
800: l_session_id HR_OWNER_DEFINITIONS.SESSION_ID%TYPE;
801: l_session_id1 HR_OWNER_DEFINITIONS.SESSION_ID%TYPE;
802:

Line 977: from per_business_groups

973: --
974: cursor get_business_group_id
975: is
976: select business_group_id
977: from per_business_groups
978: where upper(name) = p_bg_name;
979: --
980: cursor get_bal_cat_id(p_bg_id number)
981: is

Line 1034: from per_business_groups

1030: --
1031: cursor get_business_group_id
1032: is
1033: select business_group_id
1034: from per_business_groups
1035: where upper(name) = p_bg_name;
1036: --
1037: cursor get_att_def_id(p_bg_id number)
1038: is