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.HR_JPBAL dependencies on PAY_BALANCE_DIMENSIONS

Line 310: pay_balance_dimensions pbd

306: is
307: SELECT /*+ ORDERED */
308: pdb.defined_balance_id
309: FROM pay_defined_balances pdb,
310: pay_balance_dimensions pbd
311: WHERE pdb.balance_type_id = c_balance_type_id
312: AND pbd.balance_dimension_id = pdb.balance_dimension_id
313: AND pbd.dimension_name = c_dimension_name;
314: --

Line 465: l_dimension_name pay_balance_dimensions.dimension_name%TYPE;

461: l_to_date DATE;
462: l_action_sequence NUMBER;
463: l_action_type pay_payroll_actions.action_type%TYPE;
464: l_business_group_id NUMBER;
465: l_dimension_name pay_balance_dimensions.dimension_name%TYPE;
466: l_dimension_jp_type VARCHAR2(15);
467: l_latest_value_exists VARCHAR(2);
468: --
469: cursor action_context

Line 486: FROM pay_balance_dimensions DIM,

482: cursor balance_dimension
483: is
484: SELECT DB.balance_type_id,
485: DIM.dimension_name
486: FROM pay_balance_dimensions DIM,
487: pay_defined_balances DB
488: WHERE DB.defined_balance_id = p_defined_balance_id
489: AND DIM.balance_dimension_id = DB.balance_dimension_id;
490: BEGIN

Line 675: l_database_item_suffix pay_balance_dimensions.database_item_suffix%type;

671: p_start_dd_mm IN VARCHAR2,
672: p_frequency IN NUMBER)
673: IS
674: l_start_dd_mm varchar2(5);
675: l_database_item_suffix pay_balance_dimensions.database_item_suffix%type;
676: l_dimension_name pay_balance_dimensions.dimension_name%type;
677: l_route_id number;
678: l_balance_dimension_id number;
679: l_route_text ff_routes.text%type;

Line 676: l_dimension_name pay_balance_dimensions.dimension_name%type;

672: p_frequency IN NUMBER)
673: IS
674: l_start_dd_mm varchar2(5);
675: l_database_item_suffix pay_balance_dimensions.database_item_suffix%type;
676: l_dimension_name pay_balance_dimensions.dimension_name%type;
677: l_route_id number;
678: l_balance_dimension_id number;
679: l_route_text ff_routes.text%type;
680: l_dimension_type pay_balance_dimensions.dimension_type%type;

Line 680: l_dimension_type pay_balance_dimensions.dimension_type%type;

676: l_dimension_name pay_balance_dimensions.dimension_name%type;
677: l_route_id number;
678: l_balance_dimension_id number;
679: l_route_text ff_routes.text%type;
680: l_dimension_type pay_balance_dimensions.dimension_type%type;
681: l_expiry_checking_level pay_balance_dimensions.expiry_checking_level%type;
682: l_expiry_checking_code pay_balance_dimensions.expiry_checking_code%type;
683: l_description pay_balance_dimensions.description%type;
684: l_request_id number := fnd_profile.value('CONC_REQUEST_ID');

Line 681: l_expiry_checking_level pay_balance_dimensions.expiry_checking_level%type;

677: l_route_id number;
678: l_balance_dimension_id number;
679: l_route_text ff_routes.text%type;
680: l_dimension_type pay_balance_dimensions.dimension_type%type;
681: l_expiry_checking_level pay_balance_dimensions.expiry_checking_level%type;
682: l_expiry_checking_code pay_balance_dimensions.expiry_checking_code%type;
683: l_description pay_balance_dimensions.description%type;
684: l_request_id number := fnd_profile.value('CONC_REQUEST_ID');
685: l_rowid rowid;

Line 682: l_expiry_checking_code pay_balance_dimensions.expiry_checking_code%type;

678: l_balance_dimension_id number;
679: l_route_text ff_routes.text%type;
680: l_dimension_type pay_balance_dimensions.dimension_type%type;
681: l_expiry_checking_level pay_balance_dimensions.expiry_checking_level%type;
682: l_expiry_checking_code pay_balance_dimensions.expiry_checking_code%type;
683: l_description pay_balance_dimensions.description%type;
684: l_request_id number := fnd_profile.value('CONC_REQUEST_ID');
685: l_rowid rowid;
686: --

Line 683: l_description pay_balance_dimensions.description%type;

679: l_route_text ff_routes.text%type;
680: l_dimension_type pay_balance_dimensions.dimension_type%type;
681: l_expiry_checking_level pay_balance_dimensions.expiry_checking_level%type;
682: l_expiry_checking_code pay_balance_dimensions.expiry_checking_code%type;
683: l_description pay_balance_dimensions.description%type;
684: l_request_id number := fnd_profile.value('CONC_REQUEST_ID');
685: l_rowid rowid;
686: --
687: cursor csr_language_code is

Line 725: select pay_balance_dimensions_s.nextval

721: select ff_routes_s.nextval
722: into l_route_id
723: from dual;
724: --
725: select pay_balance_dimensions_s.nextval
726: into l_balance_dimension_id
727: from dual;
728: --
729: l_route_text :=

Line 797: insert into pay_balance_dimensions(

793: l_expiry_checking_level := 'P';
794: l_expiry_checking_code := 'hr_jpbal.check_expiry';
795: l_description := hr_jp_standard_pkg.get_message('PAY', 'PAY_JP_USER_DEF_ASG_DIM_DESC', 'US', 'REQUEST_ID', to_char(l_request_id));
796: --
797: insert into pay_balance_dimensions(
798: balance_dimension_id,
799: business_group_id,
800: legislation_code,
801: route_id,

Line 860: from pay_balance_dimensions_tl

856: --
857: begin
858: select rowid
859: into l_rowid
860: from pay_balance_dimensions_tl
861: where balance_dimension_id = l_balance_dimension_id
862: and language = l_rec.language_code
863: for update nowait;
864: --

Line 865: update pay_balance_dimensions_tl

861: where balance_dimension_id = l_balance_dimension_id
862: and language = l_rec.language_code
863: for update nowait;
864: --
865: update pay_balance_dimensions_tl
866: set dimension_name = l_database_item_suffix,
867: database_item_suffix = l_database_item_suffix,
868: description = l_description
869: where rowid = l_rowid;

Line 872: insert into pay_balance_dimensions_tl(

868: description = l_description
869: where rowid = l_rowid;
870: exception
871: when no_data_found then
872: insert into pay_balance_dimensions_tl(
873: BALANCE_DIMENSION_ID,
874: LANGUAGE,
875: SOURCE_LANG,
876: DIMENSION_NAME,

Line 2889: pay_balance_dimensions pbd

2885: SELECT /*+ ORDERED */
2886: pdb.balance_type_id,
2887: pbd.dimension_name
2888: FROM pay_defined_balances pdb,
2889: pay_balance_dimensions pbd
2890: WHERE pdb.defined_balance_id = c_defined_balance_id
2891: AND pbd.balance_dimension_id = pdb.balance_dimension_id;
2892: --
2893: BEGIN

Line 3003: pay_balance_dimensions pbd

2999: SELECT /*+ ORDERED */
3000: pdb.balance_type_id,
3001: pbd.dimension_name
3002: FROM pay_defined_balances pdb,
3003: pay_balance_dimensions pbd
3004: WHERE pdb.defined_balance_id = c_defined_balance_id
3005: AND pbd.balance_dimension_id = pdb.balance_dimension_id;
3006: --
3007: BEGIN