APPS.PQP_EXPREPLOD_PKG dependencies on PAY_BALANCE_DIMENSIONS

Line 213: FROM pay_balance_dimensions where balance_dimension_id =

209: SELECT INSTR(DATABASE_ITEM_SUFFIX,'_GRE_'),
210: INSTR(DATABASE_ITEM_SUFFIX,'_LE_') ,
211: INSTR(DATABASE_ITEM_SUFFIX,'_COMP_'),
212: INSTR(DATABASE_ITEM_SUFFIX,'_TU_')
213: FROM pay_balance_dimensions where balance_dimension_id =
214: (SELECT balance_dimension_id
215: FROM pay_defined_balances
216: WHERE defined_balance_id =p_defined_balance_id
217: );

Line 361: FROM pay_balance_dimensions where balance_dimension_id =

357: l_total_value NUMBER := 0;
358: l_orgname hr_organization_units.name%TYPE;
359: CURSOR c_get_bal_dim IS
360: SELECT INSTR(DATABASE_ITEM_SUFFIX,'_GRE_')
361: FROM pay_balance_dimensions where balance_dimension_id =
362: (SELECT balance_dimension_id
363: FROM pay_defined_balances
364: WHERE defined_balance_id =p_defined_balance_id
365: );

Line 1421: ,p_dimension_type_id IN pay_balance_dimensions.balance_dimension_id%TYPE

1417: -- =============================================================================
1418: FUNCTION Get_Tax_Start_Date
1419: (p_legislation_code IN VARCHAR2
1420: ,p_effective_date IN Date
1421: ,p_dimension_type_id IN pay_balance_dimensions.balance_dimension_id%TYPE
1422: ) RETURN date IS
1423:
1424: CURSOR c_tax_start_date(c_dimension_type_id IN NUMBER
1425: ,c_legislation_code IN VARCHAR2) IS

Line 1430: FROM pay_balance_dimensions

1426: SELECT pers.year_begin_date
1427: FROM pqp_exception_report_suffix pers
1428: WHERE pers.database_item_suffix =(
1429: SELECT database_item_suffix
1430: FROM pay_balance_dimensions
1431: WHERE balance_dimension_id =c_dimension_type_id
1432: AND legislation_code=c_legislation_code)
1433: AND pers.legislation_code=c_legislation_code;
1434: