APPS.PAY_AE_ELEMENT_TEMPLATE_PKG dependencies on PAY_ELEMENT_TEMPLATES

Line 303: FROM pay_element_templates

299: CURSOR csr_get_template_info IS
300: SELECT base_name
301: ,business_group_id
302: ,template_name
303: FROM pay_element_templates
304: WHERE template_id = p_template_id
305: AND template_type = 'U';
306: rec_get_template_info csr_get_template_info%ROWTYPE;
307:

Line 368: l_template_name pay_element_templates.template_name%TYPE;

364: l_element_type_id NUMBER;
365: l_info_element_type_id NUMBER;
366: l_classification_id NUMBER;
367: l_input_value_id NUMBER;
368: l_template_name pay_element_templates.template_name%TYPE;
369: l_value_set_id NUMBER;
370: l_ov_number NUMBER;
371: l_effective_date DATE;
372: l_effective_start_date DATE;

Line 611: FROM pay_element_templates

607: l_bal_feed_id number;
608: --
609: CURSOR c_template IS
610: SELECT template_id
611: FROM pay_element_templates
612: WHERE template_name = 'Flat Amount Template'
613: AND template_type = 'T';
614: --
615: BEGIN

Line 854: FROM pay_element_templates

850: l_excl_rule_id_perc number;
851: --
852: CURSOR c_template IS
853: SELECT template_id
854: FROM pay_element_templates
855: WHERE template_name = 'Percentage of Basic Salary Template'
856: AND template_type = 'T';
857: --
858: BEGIN

Line 1096: FROM pay_element_templates

1092: l_bal_feed_id number;
1093: --
1094: CURSOR c_template IS
1095: SELECT template_id
1096: FROM pay_element_templates
1097: WHERE template_name = 'Grade Allowance Template'
1098: AND template_type = 'T';
1099: --
1100: BEGIN

Line 1356: FROM pay_element_templates

1352: l_bal_feed_id number;
1353: --
1354: CURSOR c_template IS
1355: SELECT template_id
1356: FROM pay_element_templates
1357: WHERE template_name = 'Housing Allowance Template'
1358: AND template_type = 'T';
1359: --
1360: BEGIN

Line 1834: FROM pay_element_templates

1830: l_bal_feed_id number;
1831: --
1832: CURSOR c_template IS
1833: SELECT template_id
1834: FROM pay_element_templates
1835: WHERE template_name = 'Transport Allowance Template'
1836: AND template_type = 'T';
1837: --
1838: BEGIN

Line 2223: FROM pay_element_templates

2219: l_bal_feed_id number;
2220: --
2221: CURSOR c_template IS
2222: SELECT template_id
2223: FROM pay_element_templates
2224: WHERE template_name = 'Cost of Living Allowance Template'
2225: AND template_type = 'T';
2226: --
2227: BEGIN

Line 2533: FROM pay_element_templates

2529: l_bal_feed_id number;
2530: --
2531: CURSOR c_template IS
2532: SELECT template_id
2533: FROM pay_element_templates
2534: WHERE template_name = 'Children Social Allowance Template'
2535: AND template_type = 'T';
2536: --
2537: BEGIN

Line 2840: FROM pay_element_templates

2836: l_bal_feed_id number;
2837: --
2838: CURSOR c_template IS
2839: SELECT template_id
2840: FROM pay_element_templates
2841: WHERE template_name = 'Social Allowance Template'
2842: AND template_type = 'T';
2843: --
2844: BEGIN

Line 3102: FROM pay_element_templates

3098: l_bal_feed_id number;
3099: --
3100: CURSOR c_template IS
3101: SELECT template_id
3102: FROM pay_element_templates
3103: WHERE template_name = 'Shift Allowance Template'
3104: AND template_type = 'T';
3105: --
3106: BEGIN

Line 3424: FROM pay_element_templates

3420: l_bal_feed_id number;
3421: --
3422: CURSOR c_template IS
3423: SELECT template_id
3424: FROM pay_element_templates
3425: WHERE template_name = 'Hourly Salary Template'
3426: AND template_type = 'T';
3427: --
3428: BEGIN

Line 3697: FROM pay_element_templates

3693: l_bal_feed_id number;
3694: --
3695: CURSOR c_template IS
3696: SELECT template_id
3697: FROM pay_element_templates
3698: WHERE template_name = 'Overtime Allowance Template'
3699: AND template_type = 'T';
3700: --
3701: BEGIN

Line 4053: FROM pay_element_templates

4049:
4050: --
4051: CURSOR c_template IS
4052: SELECT template_id
4053: FROM pay_element_templates
4054: WHERE template_name = 'Unpaid Leave Template'
4055: AND template_type = 'T';
4056: --
4057: BEGIN