APPS.PN_RXI_REP SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 27

     delete PN_SPACE_ASSIGN_LOC_ITF
     where creation_date between l_date_from and l_date_to;

Line: 30

     pnp_debug_pkg.put_log_msg('pnp_rxi_rep.purge - deleted PN_SPACE_ASSIGN_LOC_ITF');

Line: 36

     delete PN_SPACE_ASSIGN_LEASE_ITF
     where creation_date between l_date_from and l_date_to;

Line: 39

     pnp_debug_pkg.put_log_msg('pnp_rxi_rep.purge - deleted PN_SPACE_ASSIGN_LEASE_ITF');

Line: 45

     delete PN_SPACE_UTIL_LOC_ITF
     where creation_date between l_date_from and l_date_to;

Line: 48

     pnp_debug_pkg.put_log_msg('pnp_rxi_rep.purge - deleted PN_SPACE_UTIL_LOC_ITF');

Line: 54

     delete PN_SPACE_UTIL_LEASE_ITF
     where creation_date between l_date_from and l_date_to;

Line: 57

     pnp_debug_pkg.put_log_msg('pnp_rxi_rep.purge - deleted PN_SPACE_UTIL_LEASE_ITF');

Line: 63

     delete PN_RENT_ROLL_LEASE_EXP_ITF
     where creation_date between l_date_from and l_date_to;

Line: 66

     pnp_debug_pkg.put_log_msg('pnp_rxi_rep.purge - deleted PN_RENT_ROLL_LEASE_EXP_ITF');

Line: 72

     delete PN_LEASE_OPTIONS_ITF
     where creation_date between l_date_from and l_date_to;

Line: 75

     pnp_debug_pkg.put_log_msg('pnp_rxi_rep.purge - deleted PN_LEASE_OPTIONS_ITF');

Line: 81

     delete PN_MILESTONES_ITF
     where creation_date between l_date_from and l_date_to;

Line: 84

     pnp_debug_pkg.put_log_msg('pnp_rxi_rep.purge - deleted PN_MILESTONES_ITF');