APPS.PAY_US_PSD_UPGRADE_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 386: FROM pay_element_types_f pet,

382: include_or_exclude)
383: SELECT DISTINCT pet.element_type_id,
384: l_element_set_id,
385: 'I'
386: FROM pay_element_types_f pet,
387: pay_input_values_f piv,
388: per_business_groups pbg
389: WHERE NVL(pet.legislation_code,'US') = 'US'
390: AND NVL(pet.business_group_id,pbg.business_group_id) = pbg.business_group_id

Line 686: pay_element_types_f pet,

682: ,p_mode
683: ,substr(pumg.city_name,8,6)
684: FROM pay_run_results prr,
685: pay_us_modified_geocodes pumg,
686: pay_element_types_f pet,
687: pay_input_values_f piv
688: WHERE prr.assignment_action_id = tab_assignment_action_id(i)
689: AND length(prr.jurisdiction_code) = 16
690: AND substr(prr.jurisdiction_code,1,2) = '39'

Line 735: pay_element_types_f pet,

731: ,substr(pumg.city_name,8,6)
732: FROM pay_run_results prr,
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