APPS.PAY_US_PSD_UPGRADE_PKG dependencies on PAY_ELEMENT_TYPE_RULES

Line 379: INSERT INTO pay_element_type_rules

375: 'US',
376: 'US_JSD_ELEMENTS_'||p_pay_patch_status_id,
377: 'D');
378:
379: INSERT INTO pay_element_type_rules
380: (element_type_id,
381: element_set_id,
382: include_or_exclude)
383: SELECT DISTINCT pet.element_type_id,

Line 622: pay_element_type_rules petr,

618: ,substr(pumg.city_name,8,6)
619: FROM pay_element_entries_f pee,
620: pay_element_entry_values_f peev,
621: pay_input_values_f piv,
622: pay_element_type_rules petr,
623: pay_us_modified_geocodes pumg
624: WHERE pee.assignment_id = p_assignment_id
625: AND pee.element_type_id = petr.element_type_id
626: AND peev.element_entry_id = pee.element_entry_id

Line 737: pay_element_type_rules petr

733: pay_run_result_values prv,
734: pay_us_modified_geocodes pumg,
735: pay_element_types_f pet,
736: pay_input_values_f piv,
737: pay_element_type_rules petr
738: WHERE prr.assignment_action_id = tab_assignment_action_id(i)
739: AND prr.run_result_id = prv.run_result_id
740: AND length(prv.result_value) = 16
741: AND substr(prv.result_value,1,2) = '39'

Line 1866: DELETE FROM pay_element_type_rules

1862: pay_us_psd_upgrade_pkg.generate_output(l_mode);
1863:
1864: invalidate_run_balances(l_mode);
1865:
1866: DELETE FROM pay_element_type_rules
1867: WHERE element_set_id IN
1868: (SELECT element_set_id
1869: FROM pay_element_sets
1870: WHERE element_set_name = 'US_JSD_ELEMENTS_'||l_id);