APPS.PQP_EXPREPLOD_PKG dependencies on PQP_EXCEPTION_REPORT_SUFFIX

Line 1427: FROM pqp_exception_report_suffix pers

1423:
1424: CURSOR c_tax_start_date(c_dimension_type_id IN NUMBER
1425: ,c_legislation_code IN VARCHAR2) IS
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

Line 1436: l_tax_year_start pqp_exception_report_suffix.year_begin_date%TYPE;

1432: AND legislation_code=c_legislation_code)
1433: AND pers.legislation_code=c_legislation_code;
1434:
1435:
1436: l_tax_year_start pqp_exception_report_suffix.year_begin_date%TYPE;
1437: l_tax_year_start_dt Date;
1438: l_proc_name Varchar2(150) := g_proc_name ||'Get_Tax_Start_Date';
1439:
1440: BEGIN