APPS.PQP_EXPREPLOD_PKG dependencies on PAY_BALANCE_DIMENSIONS

Line 210: FROM pay_balance_dimensions where balance_dimension_id =

206: l_orgname hr_organization_units.name%TYPE;
207: CURSOR c_get_bal_dim IS
208: SELECT INSTR(DATABASE_ITEM_SUFFIX,'_GRE_'),
209: INSTR(DATABASE_ITEM_SUFFIX,'_LE_')
210: FROM pay_balance_dimensions where balance_dimension_id =
211: (SELECT balance_dimension_id
212: FROM pay_defined_balances
213: WHERE defined_balance_id =p_defined_balance_id
214: );

Line 1241: ,p_dimension_type_id IN pay_balance_dimensions.balance_dimension_id%TYPE

1237: -- =============================================================================
1238: FUNCTION Get_Tax_Start_Date
1239: (p_legislation_code IN VARCHAR2
1240: ,p_effective_date IN Date
1241: ,p_dimension_type_id IN pay_balance_dimensions.balance_dimension_id%TYPE
1242: ) RETURN date IS
1243:
1244: CURSOR c_tax_start_date(c_dimension_type_id IN NUMBER
1245: ,c_legislation_code IN VARCHAR2) IS

Line 1250: FROM pay_balance_dimensions

1246: SELECT pers.year_begin_date
1247: FROM pqp_exception_report_suffix pers
1248: WHERE pers.database_item_suffix =(
1249: SELECT database_item_suffix
1250: FROM pay_balance_dimensions
1251: WHERE balance_dimension_id =c_dimension_type_id
1252: AND legislation_code=c_legislation_code)
1253: AND pers.legislation_code=c_legislation_code;
1254: