APPS.PAY_US_ITERATIVE_VALUES dependencies on PAY_INPUT_VALUES_F

Line 537: from pay_input_values_f ipv

533:
534: begin
535:
536: select 'Y' into v_arrears_flag
537: from pay_input_values_f ipv
538: where ipv.name = 'Clear Arrears'
539: and p_date_earned BETWEEN ipv.effective_start_date
540: AND ipv.effective_end_date
541: and ipv.element_type_id = p_eletype_id;

Line 626: pay_input_values_f piv,

622: ,piv.name
623: ,peev.screen_entry_value
624: from pay_element_entries_f peef,
625: pay_element_entry_values_f peev,
626: pay_input_values_f piv,
627: pay_element_links_f pel,
628: pay_element_types_f pet,
629: pay_element_classifications pec
630: where peef.assignment_id = p_assignment_id

Line 703: l_ip_val_name pay_input_values_f.name%TYPE;

699:
700: l_tax_rules_date_id pay_taxability_rules_dates.taxability_rules_date_id%TYPE;
701: l_classification_id pay_element_classifications.classification_id%TYPE;
702: l_element_name pay_element_types_f.element_name%TYPE;
703: l_ip_val_name pay_input_values_f.name%TYPE;
704: l_value pay_element_entry_values_f.screen_entry_value%TYPE;
705:
706: l_other varchar2(5);
707: