APPS.PAY_CREATE_ELEMNT_TMPLT_RECORD dependencies on PAY_ELEMENT_TEMPLATES

Line 277: FROM pay_element_templates

273:
274: BEGIN
275: SELECT 'Y', Template_id
276: INTO l_template_exists, l_template_id
277: FROM pay_element_templates
278: WHERE Template_type = 'T'
279: AND Legislation_code = p_legislation_code
280: AND template_name = 'Flat Amount Deduction';
281: EXCEPTION

Line 310: -- PAY_ELEMENT_TEMPLATES row.

306:
307: l_effective_date := to_date('1901/01/01', 'YYYY/MM/DD');
308:
309: --
310: -- PAY_ELEMENT_TEMPLATES row.
311: --
312: pay_etm_ins.ins
313: (p_template_id => l_template_id
314: ,p_effective_date => l_effective_date

Line 1416: FROM pay_element_templates

1412:
1413: BEGIN
1414: SELECT 'Y', Template_id
1415: INTO l_template_exists, l_template_id
1416: FROM pay_element_templates
1417: WHERE Template_type = 'T'
1418: AND Legislation_code = p_legislation_code
1419: AND template_name = 'Flat Amount';
1420: EXCEPTION

Line 1449: -- PAY_ELEMENT_TEMPLATES row.

1445:
1446: l_effective_date := to_date('1901/01/01', 'YYYY/MM/DD');
1447:
1448: --
1449: -- PAY_ELEMENT_TEMPLATES row.
1450: --
1451: pay_etm_ins.ins
1452: (p_template_id => l_template_id
1453: ,p_effective_date => l_effective_date

Line 2046: FROM pay_element_templates

2042:
2043: BEGIN
2044: SELECT 'Y', Template_id
2045: INTO l_template_exists, l_template_id
2046: FROM pay_element_templates
2047: WHERE Template_type = 'T'
2048: AND Legislation_code = p_legislation_code
2049: AND template_name = 'Hours X Rate';
2050: EXCEPTION

Line 2079: -- PAY_ELEMENT_TEMPLATES row.

2075:
2076: l_effective_date := to_date('1901/01/01', 'YYYY/MM/DD');
2077:
2078: --
2079: -- PAY_ELEMENT_TEMPLATES row.
2080: --
2081: pay_etm_ins.ins
2082: (p_template_id => l_template_id
2083: ,p_effective_date => l_effective_date

Line 3018: FROM pay_element_templates

3014:
3015: BEGIN
3016: SELECT 'Y', Template_id
3017: INTO l_template_exists, l_template_id
3018: FROM pay_element_templates
3019: WHERE Template_type = 'T'
3020: AND Legislation_code = p_legislation_code
3021: AND template_name = 'Percentage Deduction';
3022: EXCEPTION

Line 3051: -- PAY_ELEMENT_TEMPLATES row.

3047:
3048: l_effective_date := to_date('1901/01/01', 'YYYY/MM/DD');
3049:
3050: --
3051: -- PAY_ELEMENT_TEMPLATES row.
3052: --
3053: pay_etm_ins.ins
3054: (p_template_id => l_template_id
3055: ,p_effective_date => l_effective_date

Line 4260: FROM pay_element_templates

4256:
4257: BEGIN
4258: SELECT 'Y', Template_id
4259: INTO l_template_exists, l_template_id
4260: FROM pay_element_templates
4261: WHERE Template_type = 'T'
4262: AND Legislation_code = p_legislation_code
4263: AND template_name = 'Percentage of Earnings';
4264: EXCEPTION

Line 4293: -- PAY_ELEMENT_TEMPLATES row.

4289:
4290: l_effective_date := to_date('1901/01/01', 'YYYY/MM/DD');
4291:
4292: --
4293: -- PAY_ELEMENT_TEMPLATES row.
4294: --
4295: pay_etm_ins.ins
4296: (p_template_id => l_template_id
4297: ,p_effective_date => l_effective_date