DBA Data[Home] [Help]

APPS.PQP_PRORATION_WRAPPER dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 16: FROM pay_element_classifications

12: WHERE UPPER(table_name) = UPPER(p_table_name);
13:
14: CURSOR c_primary_classification(p_primary_class IN VARCHAR2) IS
15: SELECT default_priority
16: FROM pay_element_classifications
17: WHERE NVL(legislation_code, 'GB') = 'GB'
18: AND UPPER(classification_name) = UPPER(p_primary_class);
19:
20: CURSOR c_element_id(p_ele_name IN VARCHAR2) IS

Line 1953: l_primary_class_name pay_element_classifications.classification_name%TYPE;

1949: l_count NUMBER;
1950: l_pg_id NUMBER;
1951: l_ele_id NUMBER;
1952: l_ipv_as NUMBER;
1953: l_primary_class_name pay_element_classifications.classification_name%TYPE;
1954: l_default_priority NUMBER;
1955: l_etei_id NUMBER;
1956: l_etei_ovn NUMBER;
1957: