APPS.PAY_IP_UTILITY dependencies on PQP_EXCEPTION_REPORT_SUFFIX

Line 538: FROM pqp_exception_report_suffix

534: CURSOR c_get_dimensions(cp_install_tax_unit IN VARCHAR2) IS
535: SELECT database_item_suffix, legislation_code, exception_report_period,
536: last_updated_by, last_update_date, last_update_login,
537: created_by, creation_date, object_version_number, year_begin_date
538: FROM pqp_exception_report_suffix
539: WHERE legislation_code = 'ZZ'
540: AND ((cp_install_tax_unit='N' AND INSTR(database_item_suffix,'_TU_') = 0)
541: OR cp_install_tax_unit='Y');
542:

Line 547: UPDATE pqp_exception_report_suffix

543: BEGIN
544: hr_utility.trace('Entered procedure create_pqp_rep_dim');
545: FOR rec IN c_get_dimensions(p_install_tax_unit) LOOP
546: hr_utility.trace('Database Item Suffix :'||rec.database_item_suffix);
547: UPDATE pqp_exception_report_suffix
548: SET exception_report_period = rec.exception_report_period
549: ,last_updated_by = rec.last_updated_by
550: ,last_update_date = sysdate
551: ,last_update_login = rec.last_update_login

Line 558: INSERT INTO PQP_EXCEPTION_REPORT_SUFFIX

554: AND legislation_code = p_legislation_code;
555:
556: IF SQL%ROWCOUNT = 0 THEN
557: hr_utility.trace('Inserting Database Item Suffix :'||rec.database_item_suffix);
558: INSERT INTO PQP_EXCEPTION_REPORT_SUFFIX
559: (database_item_suffix
560: , legislation_code
561: , exception_report_period
562: , last_updated_by