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.PQP_GB_PENSION_SCHEME_TEMPLATE dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 140: l_ele_class_name pay_element_classifications.classification_name%TYPE;

136: l_ele_name t_ele_name;
137: l_ele_new_name t_ele_name;
138: l_bal_name pay_balance_types.balance_name%TYPE;
139: l_bal_new_name pay_balance_types.balance_name%TYPE;
140: l_ele_class_name pay_element_classifications.classification_name%TYPE;
141: l_exc_ocp_rule_id VARCHAR2 (1);
142: l_exc_ers_cent_rule_id VARCHAR2 (1);
143: l_exc_ers_fxd_rule_id VARCHAR2 (1);
144: l_exc_adl_cent_rule_id VARCHAR2 (1);

Line 180: l_sub_class_name pay_element_classifications.classification_name%TYPE;

176: l_base_processing_priority pay_element_types_f.processing_priority%TYPE;
177: l_iterative_flag pay_element_types_f.iterative_flag%TYPE;
178: l_iterative_priority pay_element_types_f.iterative_priority%TYPE;
179: l_iterative_formula ff_formulas_f.formula_name%TYPE;
180: l_sub_class_name pay_element_classifications.classification_name%TYPE;
181: l_pensionable_sal_bal_id NUMBER;
182: l_pensionable_sal_bal_name pay_balance_types.balance_name%TYPE;
183: l_arrearage_allowed VARCHAR2 (1)
184: := NVL (p_arrearage_allowed, 'N');

Line 661: FROM pay_element_classifications

657: --
658: CURSOR csr_get_ele_class_info
659: IS
660: SELECT classification_name, default_priority
661: FROM pay_element_classifications
662: WHERE classification_id = p_classification_id;
663:
664: l_proc_name VARCHAR2 (80)
665: := g_proc_name

Line 1780: FROM pay_element_classifications

1776: --
1777: CURSOR csr_get_class_id
1778: IS
1779: SELECT classification_id
1780: FROM pay_element_classifications
1781: WHERE classification_name = p_classification_name
1782: AND legislation_code = g_template_leg_code
1783: AND business_group_id IS NULL;
1784:

Line 3932: ,pay_element_classifications pec

3928: CURSOR csr_chk_sub_class_exists
3929: IS
3930: SELECT sub.ROWID, sub.sub_classification_rule_id
3931: FROM pay_sub_classification_rules_f sub
3932: ,pay_element_classifications pec
3933: WHERE element_type_id = p_element_type_id
3934: AND sub.classification_id = pec.classification_id
3935: AND pec.classification_name IN
3936: ('Pre Tax Employee Pension COSR'