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 770: lr_Get_Defined_Balance_Id pay_defined_balances.defined_balance_id%type;

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

Line 842: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

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)
846: INDEX BY BINARY_INTEGER;