APPS.PAY_US_ITERATIVE_VALUES dependencies on PAY_ELEMENT_TYPES_F

Line 632: pay_element_types_f pet,

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

Line 695: from pay_element_types_f pet

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

Line 700: l_cur_ele_tax_cat pay_element_types_f.element_information1%TYPE;

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

Line 706: l_element_name pay_element_types_f.element_name%TYPE;

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

Line 798: from pay_element_types_f pet

794:
795: cursor c_get_partial_info is
796:
797: select pet.element_information2
798: from pay_element_types_f pet
799: where pet.element_type_id = p_element_type_id
800: and p_date_earned BETWEEN pet.effective_start_date
801: AND pet.effective_end_date;
802:

Line 803: l_partial_deduction pay_element_types_f.element_information2%TYPE;

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