APPS.PAY_US_ITERATIVE_VALUES dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 629: pay_element_classifications pec

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
633: and peef.effective_end_date

Line 662: p_classification_id pay_element_classifications.classification_id%TYPE,

658:
659: CURSOR csr_tax_rules_exists(
660: p_juri_code VARCHAR2,
661: p_tax_cat pay_taxability_rules.tax_category%TYPE,
662: p_classification_id pay_element_classifications.classification_id%TYPE,
663: p_tax_rules_date_id pay_taxability_rules.taxability_rules_date_id%TYPE
664: ) is
665: select 'Y'
666: from pay_taxability_rules

Line 701: l_classification_id pay_element_classifications.classification_id%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;
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: