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.

[Home] [Help]

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 657: FROM pay_element_classifications

653: --
654: CURSOR csr_get_ele_class_info
655: IS
656: SELECT classification_name, default_priority
657: FROM pay_element_classifications
658: WHERE classification_id = p_classification_id;
659:
660: l_proc_name VARCHAR2 (80)
661: := g_proc_name

Line 1778: FROM pay_element_classifications

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

Line 3929: ,pay_element_classifications pec

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