DBA Data[Home] [Help]

APPS.PQP_EXPREPLOD_PKG dependencies on PQP_EXCEPTION_REPORT_SUFFIX

Line 1247: FROM pqp_exception_report_suffix pers

1243:
1244: CURSOR c_tax_start_date(c_dimension_type_id IN NUMBER
1245: ,c_legislation_code IN VARCHAR2) IS
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

Line 1256: l_tax_year_start pqp_exception_report_suffix.year_begin_date%TYPE;

1252: AND legislation_code=c_legislation_code)
1253: AND pers.legislation_code=c_legislation_code;
1254:
1255:
1256: l_tax_year_start pqp_exception_report_suffix.year_begin_date%TYPE;
1257: l_tax_year_start_dt Date;
1258: l_proc_name Varchar2(150) := g_proc_name ||'Get_Tax_Start_Date';
1259:
1260: BEGIN