APPS.PAY_US_PSD_UPGRADE_PKG dependencies on PAY_INPUT_VALUES_F

Line 387: pay_input_values_f piv,

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
391: AND pbg.legislation_code = 'US'

Line 621: pay_input_values_f piv,

617: ,p_mode
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

Line 687: pay_input_values_f piv

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'
691: AND (substr(prr.jurisdiction_code,4,6) = substr(pumg.city_name,1,6) or

Line 736: pay_input_values_f piv,

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
740: AND length(prv.result_value) = 16