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_IN_BAL_UPL_STRUCT dependencies on PAY_BALANCE_TYPES

Line 102: FROM pay_balance_types

98: CURSOR csr_bal_type (l_bal_type_name IN VARCHAR2) IS
99: SELECT balance_type_id,
100: nvl(jurisdiction_level, 999),
101: balance_uom
102: FROM pay_balance_types
103: WHERE upper(balance_name) = upper(l_baltyp_name)
104: AND ((business_group_id = p_busgrp_id)
105: OR( business_group_id is null
106: AND legislation_code = p_leg_code)

Line 300: l_bt_id pay_balance_types.balance_type_id%TYPE;

296: retcode number := 0;
297: i number := 0;
298: l_bg_id per_business_groups.business_group_id%TYPE;
299: l_leg_code per_business_groups.legislation_code%TYPE;
300: l_bt_id pay_balance_types.balance_type_id%TYPE;
301: l_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;
302: l_procedure VARCHAR2(100);
303: l_message VARCHAR2(255);
304:

Line 382: l_bal_uom pay_balance_types.balance_uom%TYPE;

378: -- retcode = 0 means no error and retcode = 2 means an error occurred.
379:
380: l_n_elems number := 0;
381: j number;
382: l_bal_uom pay_balance_types.balance_uom%TYPE;
383: l_element_name pay_element_types.element_name%TYPE;
384: l_element_type_id pay_element_types.element_type_id%TYPE;
385: l_elem_link_id pay_element_links.element_link_id%TYPE;
386: l_input_val_id pay_input_values.input_value_id%TYPE;

Line 387: l_bal_name pay_balance_types.balance_name%TYPE;

383: l_element_name pay_element_types.element_name%TYPE;
384: l_element_type_id pay_element_types.element_type_id%TYPE;
385: l_elem_link_id pay_element_links.element_link_id%TYPE;
386: l_input_val_id pay_input_values.input_value_id%TYPE;
387: l_bal_name pay_balance_types.balance_name%TYPE;
388: l_bal_type_id pay_balance_types.balance_type_id%TYPE;
389: l_bal_feed_id pay_balance_feeds.balance_feed_id%TYPE;
390: l_bg_name hr_organization_units.name%TYPE;
391: l_bg_id hr_organization_units.organization_id%TYPE;

Line 388: l_bal_type_id pay_balance_types.balance_type_id%TYPE;

384: l_element_type_id pay_element_types.element_type_id%TYPE;
385: l_elem_link_id pay_element_links.element_link_id%TYPE;
386: l_input_val_id pay_input_values.input_value_id%TYPE;
387: l_bal_name pay_balance_types.balance_name%TYPE;
388: l_bal_type_id pay_balance_types.balance_type_id%TYPE;
389: l_bal_feed_id pay_balance_feeds.balance_feed_id%TYPE;
390: l_bg_name hr_organization_units.name%TYPE;
391: l_bg_id hr_organization_units.organization_id%TYPE;
392: l_jur_level number;