APPS.PAY_US_ITERATIVE_VALUES dependencies on PAY_ELEMENT_TYPES_F

Line 628: pay_element_types_f pet,

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
631: and peef.creator_type <> 'UT'
632: and p_date_earned between peef.effective_start_date

Line 691: from pay_element_types_f pet

687: and ps.state_abbrev = nvl(hrl.loc_information17,hrl.region_2);
688:
689: CURSOR c_get_tax_cat is
690: select pet.element_information1, pet.classification_id
691: from pay_element_types_f pet
692: where pet.element_type_id = p_element_type_id
693: and p_date_earned between pet.effective_start_date
694: and pet.effective_end_date;
695:

Line 696: l_cur_ele_tax_cat pay_element_types_f.element_information1%TYPE;

692: where pet.element_type_id = p_element_type_id
693: and p_date_earned between pet.effective_start_date
694: and pet.effective_end_date;
695:
696: l_cur_ele_tax_cat pay_element_types_f.element_information1%TYPE;
697: l_fed VARCHAR2(5);
698: l_state VARCHAR2(5);
699:
700: l_tax_rules_date_id pay_taxability_rules_dates.taxability_rules_date_id%TYPE;

Line 702: l_element_name pay_element_types_f.element_name%TYPE;

698: l_state VARCHAR2(5);
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);

Line 794: from pay_element_types_f pet

790:
791: cursor c_get_partial_info is
792:
793: select pet.element_information2
794: from pay_element_types_f pet
795: where pet.element_type_id = p_element_type_id
796: and p_date_earned BETWEEN pet.effective_start_date
797: AND pet.effective_end_date;
798:

Line 799: l_partial_deduction pay_element_types_f.element_information2%TYPE;

795: where pet.element_type_id = p_element_type_id
796: and p_date_earned BETWEEN pet.effective_start_date
797: AND pet.effective_end_date;
798:
799: l_partial_deduction pay_element_types_f.element_information2%TYPE;
800:
801: Begin
802: hr_utility.trace('In partial_deduction_allowed function');
803: hr_utility.trace('Element Type Id is : '|| to_char(p_element_type_id));