APPS.PAY_US_ITERATIVE_VALUES dependencies on PAY_INPUT_VALUES_F

Line 541: from pay_input_values_f ipv

537:
538: begin
539:
540: select 'Y' into v_arrears_flag
541: from pay_input_values_f ipv
542: where ipv.name = 'Clear Arrears'
543: and p_date_earned BETWEEN ipv.effective_start_date
544: AND ipv.effective_end_date
545: and ipv.element_type_id = p_eletype_id;

Line 630: pay_input_values_f piv,

626: ,piv.name
627: ,peev.screen_entry_value
628: from pay_element_entries_f peef,
629: pay_element_entry_values_f peev,
630: pay_input_values_f piv,
631: pay_element_links_f pel,
632: pay_element_types_f pet,
633: pay_element_classifications pec
634: where peef.assignment_id = p_assignment_id

Line 707: l_ip_val_name pay_input_values_f.name%TYPE;

703:
704: l_tax_rules_date_id pay_taxability_rules_dates.taxability_rules_date_id%TYPE;
705: l_classification_id pay_element_classifications.classification_id%TYPE;
706: l_element_name pay_element_types_f.element_name%TYPE;
707: l_ip_val_name pay_input_values_f.name%TYPE;
708: l_value pay_element_entry_values_f.screen_entry_value%TYPE;
709:
710: l_other varchar2(5);
711: