11: balance_type_id NUMBER,
12: balance_dimension_id NUMBER,
13: defined_balance_id NUMBER,
14: balance_narrative VARCHAR2(30),
15: balance_name pay_balance_types.balance_name%TYPE,
16: database_item_suffix pay_balance_dimensions.database_item_suffix%TYPE,
17: si_type hr_lookups.meaning%TYPE,
18: legislation_code pay_balance_dimensions.legislation_code%TYPE);
19:
74: --
75: CURSOR csr_defined_balance_id is
76: SELECT pdb.defined_balance_id
77: FROM pay_balance_dimensions pbd
78: ,pay_balance_types pbt
79: ,pay_defined_balances pdb
80: WHERE pbd.database_item_suffix = p_dimension_name
81: AND pbd.business_group_id is null
82: AND pbd.legislation_code='NL'
361: SELECT pbt.balance_name,
362: pbd.database_item_suffix,
363: pbt.legislation_code,
364: pdb.defined_balance_id
365: FROM pay_balance_types pbt,
366: pay_balance_dimensions pbd,
367: pay_defined_balances pdb
368: WHERE pdb.balance_type_id = pbt.balance_type_id
369: AND pdb.balance_dimension_id = pbd.balance_dimension_id
2432: ,p_date_earned DATE
2433: ,p_si_type VARCHAR2) IS
2434: SELECT prrv1.result_value si_type_name
2435: FROM pay_balance_feeds_f pbf
2436: ,pay_balance_types pbt
2437: ,pay_input_values_f piv
2438: ,pay_input_values_f piv1
2439: ,pay_input_values_f piv2
2440: ,pay_element_types_f pet
2708: ,p_dimension VARCHAR2
2709: ,p_bus_group_id NUMBER) IS
2710: SELECT pdb.defined_balance_id defined_balance_id
2711: FROM pay_balance_dimensions pbd
2712: ,pay_balance_types pbt
2713: ,pay_defined_balances pdb
2714: WHERE pbd.database_item_suffix = p_dimension
2715: AND pbt.balance_name = p_balance_name
2716: AND (pbt.business_group_id = p_bus_group_id
2922:
2923: --Bug 7031784
2924: CURSOR csr_chk_corr_feeds (p_element_type_id NUMBER) IS
2925: SELECT pbt.balance_name
2926: FROM pay_balance_types pbt,
2927: pay_balance_feeds_f pbf,
2928: pay_input_values_f piv
2929: WHERE pbf.balance_type_id = pbt.balance_type_id
2930: AND piv.input_value_id = pbf.input_value_id
2958: type creator_type is table of varchar2(2) index by binary_integer;
2959: l_creator_type creator_type;
2960: l_element_type_id pay_element_types_f.element_type_id%TYPE;
2961: l_run_result_id pay_run_results.run_result_id%TYPE;
2962: l_corr_bal_name pay_balance_types.balance_name%TYPE;
2963:
2964: BEGIN
2965:
2966: --
3804: AND pac.assignment_Action_id = p_run_assign_action_id;
3805: --
3806: CURSOR csr_get_translated_bal_name (p_balance_name VARCHAR2) IS
3807: SELECT NVL(pbt_tl.reporting_name,pbt_tl.balance_name) bal_name
3808: FROM pay_balance_types pbt
3809: ,pay_balance_types_tl pbt_tl
3810: WHERE pbt.balance_name = p_balance_name
3811: AND pbt.balance_type_id = pbt_tl.balance_type_id
3812: AND pbt_tl.language = USERENV('LANG');
3805: --
3806: CURSOR csr_get_translated_bal_name (p_balance_name VARCHAR2) IS
3807: SELECT NVL(pbt_tl.reporting_name,pbt_tl.balance_name) bal_name
3808: FROM pay_balance_types pbt
3809: ,pay_balance_types_tl pbt_tl
3810: WHERE pbt.balance_name = p_balance_name
3811: AND pbt.balance_type_id = pbt_tl.balance_type_id
3812: AND pbt_tl.language = USERENV('LANG');
3813: --
3816: ,p_date_earned DATE
3817: ,p_si_type VARCHAR2) IS
3818: SELECT prrv1.result_value si_type_name
3819: FROM pay_balance_feeds_f pbf
3820: ,pay_balance_types pbt
3821: ,pay_input_values_f piv
3822: ,pay_input_values_f piv1
3823: ,pay_input_values_f piv2
3824: ,pay_element_types_f pet
3940: l_non_tax_rate_run NUMBER;
3941: l_sum_non_tax_rate_run NUMBER;
3942: l_non_tax_rate_ytd NUMBER;
3943:
3944: l_balance_name pay_balance_types.balance_name%TYPE;
3945: p_balance_sit_name pay_balance_types.balance_name%TYPE;
3946: l_action_info_id NUMBER;
3947: l_ovn NUMBER;
3948: l_index NUMBER;
3941: l_sum_non_tax_rate_run NUMBER;
3942: l_non_tax_rate_ytd NUMBER;
3943:
3944: l_balance_name pay_balance_types.balance_name%TYPE;
3945: p_balance_sit_name pay_balance_types.balance_name%TYPE;
3946: l_action_info_id NUMBER;
3947: l_ovn NUMBER;
3948: l_index NUMBER;
3949: l_count NUMBER;
4514: ,p_date_earned DATE
4515: ,p_classification_id NUMBER ) IS
4516: SELECT unique prr.start_date /*pay_nl_general.get_retro_period(prr.source_id,p_date_earned)*/ RDate -- Bug 5107780
4517: FROM pay_balance_feeds_f pbf
4518: ,pay_balance_types pbt
4519: ,pay_input_values_f piv
4520: ,pay_element_types_f pet
4521: ,pay_run_results prr
4522: WHERE pbf.balance_type_id = pbt.balance_type_id
4559: ,p_classification_id NUMBER ) IS
4560: SELECT sum(fnd_number.canonical_to_number(prrv.result_value)) result_value
4561: ,pet.processing_priority priority
4562: FROM pay_balance_feeds_f pbf
4563: ,pay_balance_types pbt
4564: ,pay_input_values_f piv
4565: ,pay_element_types_f pet
4566: -- ,pay_element_types_f_tl pettl Bug 5107780
4567: ,pay_run_results prr
4604: SELECT sum(fnd_number.canonical_to_number(prrv2.result_value))
4605: ,prrv1.result_value
4606: ,pet.processing_priority
4607: FROM pay_balance_feeds_f pbf
4608: ,pay_balance_types pbt
4609: ,pay_input_values_f piv
4610: ,pay_input_values_f piv1
4611: ,pay_input_values_f piv2
4612: ,pay_element_types_f pet
4658:
4659:
4660: CURSOR csr_get_translated_bal_name (p_balance_name VARCHAR2) IS
4661: SELECT NVL(pbt_tl.reporting_name,pbt_tl.balance_name) bal_name
4662: FROM pay_balance_types pbt
4663: ,pay_balance_types_tl pbt_tl
4664: WHERE pbt.balance_name = p_balance_name
4665: AND pbt.balance_type_id = pbt_tl.balance_type_id
4666: AND pbt_tl.language = USERENV('LANG');
4659:
4660: CURSOR csr_get_translated_bal_name (p_balance_name VARCHAR2) IS
4661: SELECT NVL(pbt_tl.reporting_name,pbt_tl.balance_name) bal_name
4662: FROM pay_balance_types pbt
4663: ,pay_balance_types_tl pbt_tl
4664: WHERE pbt.balance_name = p_balance_name
4665: AND pbt.balance_type_id = pbt_tl.balance_type_id
4666: AND pbt_tl.language = USERENV('LANG');
4667: