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: AND tmp.business_group_id = pet.business_group_id;

Line 1529: ,pay_element_classifications pec

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

Line 1558: ,pay_element_classifications pec

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

Line 1561: (SELECT classification_id FROM pay_element_classifications

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

Line 1578: l_sec_class pay_element_classifications.classification_name%TYPE ;

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