APPS.PAY_US_ITERATIVE_VALUES dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 633: pay_element_classifications pec

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

Line 666: p_classification_id pay_element_classifications.classification_id%TYPE,

662:
663: CURSOR csr_tax_rules_exists(
664: p_juri_code VARCHAR2,
665: p_tax_cat pay_taxability_rules.tax_category%TYPE,
666: p_classification_id pay_element_classifications.classification_id%TYPE,
667: p_tax_rules_date_id pay_taxability_rules.taxability_rules_date_id%TYPE
668: ) is
669: select 'Y'
670: from pay_taxability_rules

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