APPS.PAY_SE_SALARY_STRUCTURE_STATS dependencies on PAY_BALANCE_TYPES

Line 682: pay_balance_types pbt

678: CURSOR csr_balances(csr_v_business_group_id hr_organization_units.business_group_id%type,
679: csr_v_category_name pay_balance_categories.category_name%type)
680: IS
681: SELECT balance_type_id FRoM
682: pay_balance_types pbt
683: WHERE (legislation_code='SE'
684: OR business_group_id=csr_v_business_group_id)
685: --AND pbt.balance_name LIKE 'Steering%'
686: AND pbt.BALANCE_CATEGORY_ID=(SELECT

Line 693: CURSOR csr_defined_balances(csr_v_balance_type_id pay_balance_types.balance_type_id%TYPE)

689: legislation_code='SE'
690: AND category_name=csr_v_category_name/*'001- Hours worked (September)'*/);
691:
692: /*Defined Balances for the balances with peson level YTD dimension */
693: CURSOR csr_defined_balances(csr_v_balance_type_id pay_balance_types.balance_type_id%TYPE)
694: IS
695: SELECT pdb.defined_balance_id
696: FROM pay_balance_types pbt,
697: pay_defined_balances pdb

Line 696: FROM pay_balance_types pbt,

692: /*Defined Balances for the balances with peson level YTD dimension */
693: CURSOR csr_defined_balances(csr_v_balance_type_id pay_balance_types.balance_type_id%TYPE)
694: IS
695: SELECT pdb.defined_balance_id
696: FROM pay_balance_types pbt,
697: pay_defined_balances pdb
698: WHERE pbt.balance_type_id=pdb.balance_type_id
699: AND pbt.balance_type_id=csr_v_balance_type_id --10506678
700: AND pdb.BALANCE_DIMENSION_ID=(SELECT

Line 841: l_balance_type_id pay_balance_types.balance_type_id%TYPE;

837: l_808_steering_code NUMBER:=0;
838:
839:
840:
841: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
842: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
843:
844: TYPE emp_cat_type
845: IS TABLE OF VARCHAR2(10)