APPS.PAY_SE_SALARY_STRUCTURE_STATS dependencies on PAY_DEFINED_BALANCES

Line 697: pay_defined_balances pdb

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
701: balance_dimension_id FROM

Line 772: lr_Get_Defined_Balance_Id pay_defined_balances.defined_balance_id%type;

768: l_gross_salary number;
769: --l_start_date date;
770: --l_end_date date;
771: l_termination_date date;
772: lr_Get_Defined_Balance_Id pay_defined_balances.defined_balance_id%type;
773: l_value number;
774: L_CFAR_NUMBER NUMBER;
775: l_legal_employer_id hr_organization_units.organization_id%TYPE;
776: l_virtual_date DATE;

Line 844: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

840: l_hour_sal CHAR(1);
841:
842:
843: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
844: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
845:
846: TYPE emp_cat_type
847: IS TABLE OF VARCHAR2(10)
848: INDEX BY BINARY_INTEGER;