APPS.PAY_SE_SALARY_STRUCTURE_STATS dependencies on PAY_BALANCE_CATEGORIES

Line 679: csr_v_category_name pay_balance_categories.category_name%type)

675: WHERE payroll_id=csr_v_payroll_id;
676:
677: /*Balances under the Balance Category*/
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'

Line 688: PAY_BALANCE_CATEGORIES_F WHERE

684: OR business_group_id=csr_v_business_group_id)
685: --AND pbt.balance_name LIKE 'Steering%'
686: AND pbt.BALANCE_CATEGORY_ID=(SELECT
687: BALANCE_CATEGORY_ID FROM
688: PAY_BALANCE_CATEGORIES_F WHERE
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 */