eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IN_ELEMENT_TEMPLATE_PKG dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 1059: l_classification_id pay_element_classifications.classification_id%TYPE ;

1055: PROCEDURE create_template_association
1056: (p_template_id IN NUMBER
1057: ,p_classification IN VARCHAR2 )
1058: IS
1059: l_classification_id pay_element_classifications.classification_id%TYPE ;
1060: l_exists NUMBER;
1061: l_ele_tmplt_class_id NUMBER;
1062:
1063: l_procedure CONSTANT VARCHAR2(100):= g_package||'create_template_association';

Line 1072: FROM pay_element_classifications

1068: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1069:
1070: SELECT classification_id
1071: INTO l_classification_id
1072: FROM pay_element_classifications
1073: WHERE legislation_code = pay_in_etw_struct.g_legislation_code
1074: AND classification_name = p_classification;
1075:
1076: pay_in_utils.set_location(g_debug,l_procedure,20);

Line 1143: ,pay_element_classifications pec

1139: DELETE FROM pay_ele_tmplt_class_usages
1140: WHERE ele_template_classification_id
1141: IN (SELECT petcu.ele_template_classification_id
1142: FROM pay_ele_tmplt_class_usages petcu
1143: ,pay_element_classifications pec
1144: ,pay_element_templates pet
1145: WHERE petcu.classification_id = pec.classification_id
1146: AND petcu.template_id = pet.template_id
1147: AND pet.template_name = p_template_name

Line 1518: ,pay_element_classifications pec

1514: ,pet.element_name
1515: ,pet.reporting_name
1516: FROM pay_element_types_f pet
1517: ,pay_element_templates tmp
1518: ,pay_element_classifications pec
1519: WHERE pet.element_name = tmp.base_name
1520: AND tmp.template_id = p_template_id
1521: AND pet.classification_id = pec.classification_id;
1522:

Line 1528: ,pay_element_classifications pec

1524: , p_business_group_id NUMBER) IS
1525: SELECT pet.element_type_id
1526: ,pet.object_version_number
1527: FROM pay_element_types_f pet
1528: ,pay_element_classifications pec
1529: WHERE pet.element_name = p_base_name || ' Paid MP'
1530: AND pet.classification_id = pec.classification_id
1531: AND pet.business_group_id = p_business_group_id
1532: AND pec.classification_name = 'Paid Monetary Perquisite'

Line 1557: ,pay_element_classifications pec

1553: ,p_effective_date IN DATE )
1554: IS
1555: SELECT pec.classification_name
1556: FROM pay_sub_classification_rules_f pscr
1557: ,pay_element_classifications pec
1558: WHERE pscr.classification_id = pec.classification_id
1559: AND pec.parent_classification_id =
1560: (SELECT classification_id FROM pay_element_classifications
1561: WHERE classification_name = 'Perquisites'

Line 1560: (SELECT classification_id FROM pay_element_classifications

1556: FROM pay_sub_classification_rules_f pscr
1557: ,pay_element_classifications pec
1558: WHERE pscr.classification_id = pec.classification_id
1559: AND pec.parent_classification_id =
1560: (SELECT classification_id FROM pay_element_classifications
1561: WHERE classification_name = 'Perquisites'
1562: AND legislation_code = 'IN')
1563: AND element_type_id = p_element_id
1564: AND p_effective_date BETWEEN pscr.effective_start_date

Line 1577: l_sec_class pay_element_classifications.classification_name%TYPE ;

1573: WHERE element_name = p_element_name || ' Paid MP'
1574: AND business_group_id = p_business_group_id
1575: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
1576:
1577: l_sec_class pay_element_classifications.classification_name%TYPE ;
1578: l_exp_nature VARCHAR2(1);
1579:
1580: l_et_start_date DATE ;
1581: l_et_end_date DATE ;