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 716: select pay_balance_dimensions_s.nextval

712: select ff_routes_s.nextval
713: into l_route_id
714: from dual;
715: --
716: select pay_balance_dimensions_s.nextval
717: into l_balance_dimension_id
718: from dual;
719: --
720: l_route_text :=

Line 788: insert into pay_balance_dimensions(

784: l_expiry_checking_level := 'P';
785: l_expiry_checking_code := 'hr_jpbal.check_expiry';
786: l_description := hr_jp_standard_pkg.get_message('PAY', 'PAY_JP_USER_DEF_ASG_DIM_DESC', 'US', 'REQUEST_ID', to_char(l_request_id));
787: --
788: insert into pay_balance_dimensions(
789: balance_dimension_id,
790: business_group_id,
791: legislation_code,
792: route_id,

Line 840: from pay_balance_dimensions_tl

836: --
837: begin
838: select rowid
839: into l_rowid
840: from pay_balance_dimensions_tl
841: where balance_dimension_id = l_balance_dimension_id
842: and language = l_rec.language_code
843: for update nowait;
844: --

Line 845: update pay_balance_dimensions_tl

841: where balance_dimension_id = l_balance_dimension_id
842: and language = l_rec.language_code
843: for update nowait;
844: --
845: update pay_balance_dimensions_tl
846: set dimension_name = l_database_item_suffix,
847: database_item_suffix = l_database_item_suffix,
848: description = l_description
849: where rowid = l_rowid;

Line 852: insert into pay_balance_dimensions_tl(

848: description = l_description
849: where rowid = l_rowid;
850: exception
851: when no_data_found then
852: insert into pay_balance_dimensions_tl(
853: BALANCE_DIMENSION_ID,
854: LANGUAGE,
855: SOURCE_LANG,
856: DIMENSION_NAME,

Line 2869: pay_balance_dimensions pbd

2865: SELECT /*+ ORDERED */
2866: pdb.balance_type_id,
2867: pbd.dimension_name
2868: FROM pay_defined_balances pdb,
2869: pay_balance_dimensions pbd
2870: WHERE pdb.defined_balance_id = c_defined_balance_id
2871: AND pbd.balance_dimension_id = pdb.balance_dimension_id;
2872: --
2873: BEGIN

Line 2983: pay_balance_dimensions pbd

2979: SELECT /*+ ORDERED */
2980: pdb.balance_type_id,
2981: pbd.dimension_name
2982: FROM pay_defined_balances pdb,
2983: pay_balance_dimensions pbd
2984: WHERE pdb.defined_balance_id = c_defined_balance_id
2985: AND pbd.balance_dimension_id = pdb.balance_dimension_id;
2986: --
2987: BEGIN