APPS.PAY_CN_BAL_UPL_STRUCT dependencies on PAY_BALANCE_TYPES

Line 139: l_balance_type_id pay_balance_types.balance_type_id%TYPE;

135: ,p_busgrp_id NUMBER
136: ,p_leg_code VARCHAR2
137: ,retcode OUT NOCOPY NUMBER)
138: IS
139: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
140: l_baltyp_name pay_balance_types.balance_name%TYPE;
141: l_bal_uom pay_balance_types.balance_uom%TYPE;
142: l_jurisdiction_level NUMBER;
143: l_count NUMBER;

Line 140: l_baltyp_name pay_balance_types.balance_name%TYPE;

136: ,p_leg_code VARCHAR2
137: ,retcode OUT NOCOPY NUMBER)
138: IS
139: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
140: l_baltyp_name pay_balance_types.balance_name%TYPE;
141: l_bal_uom pay_balance_types.balance_uom%TYPE;
142: l_jurisdiction_level NUMBER;
143: l_count NUMBER;
144: l_found BOOLEAN;

Line 141: l_bal_uom pay_balance_types.balance_uom%TYPE;

137: ,retcode OUT NOCOPY NUMBER)
138: IS
139: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
140: l_baltyp_name pay_balance_types.balance_name%TYPE;
141: l_bal_uom pay_balance_types.balance_uom%TYPE;
142: l_jurisdiction_level NUMBER;
143: l_count NUMBER;
144: l_found BOOLEAN;
145:

Line 150: FROM pay_balance_types

146: CURSOR csr_bal_type (l_bal_type_name IN VARCHAR2) IS
147: SELECT balance_type_id,
148: nvl(jurisdiction_level, 999),
149: balance_uom
150: FROM pay_balance_types
151: WHERE balance_name = l_baltyp_name
152: AND ( ( business_group_id = p_busgrp_id)
153: OR ( business_group_id IS null
154: AND legislation_code = p_leg_code

Line 367: l_bt_id pay_balance_types.balance_type_id%TYPE;

363: retcode NUMBER := 0;
364: i NUMBER := 0;
365: l_bg_id per_business_groups.business_group_id%TYPE;
366: l_leg_code per_business_groups.legislation_code%TYPE;
367: l_bt_id pay_balance_types.balance_type_id%TYPE;
368: l_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;
369: --
370: CURSOR csr_bg IS
371: SELECT hou.business_group_id,

Line 462: l_bal_uom pay_balance_types.balance_uom%TYPE;

458: IS
459:
460: l_n_elems NUMBER := 0;
461: j NUMBER;
462: l_bal_uom pay_balance_types.balance_uom%TYPE;
463: l_element_name pay_element_types.element_name%TYPE;
464: l_element_type_id pay_element_types.element_type_id%TYPE;
465: l_elem_link_id pay_element_links.element_link_id%TYPE;
466: l_input_val_id pay_input_values.input_value_id%TYPE;

Line 467: l_bal_name pay_balance_types.balance_name%TYPE;

463: l_element_name pay_element_types.element_name%TYPE;
464: l_element_type_id pay_element_types.element_type_id%TYPE;
465: l_elem_link_id pay_element_links.element_link_id%TYPE;
466: l_input_val_id pay_input_values.input_value_id%TYPE;
467: l_bal_name pay_balance_types.balance_name%TYPE;
468: l_bal_type_id pay_balance_types.balance_type_id%TYPE;
469: l_bal_feed_id pay_balance_feeds.balance_feed_id%TYPE;
470: l_bg_name hr_organization_units.name%TYPE;
471: l_bg_id hr_organization_units.organization_id%TYPE;

Line 468: l_bal_type_id pay_balance_types.balance_type_id%TYPE;

464: l_element_type_id pay_element_types.element_type_id%TYPE;
465: l_elem_link_id pay_element_links.element_link_id%TYPE;
466: l_input_val_id pay_input_values.input_value_id%TYPE;
467: l_bal_name pay_balance_types.balance_name%TYPE;
468: l_bal_type_id pay_balance_types.balance_type_id%TYPE;
469: l_bal_feed_id pay_balance_feeds.balance_feed_id%TYPE;
470: l_bg_name hr_organization_units.name%TYPE;
471: l_bg_id hr_organization_units.organization_id%TYPE;
472: l_jur_level NUMBER;