APPS.PAY_CREATE_ELEMNT_TMPLT_RECORD dependencies on PAY_ELEMENT_TEMPLATES

Line 256: FROM pay_element_templates

252:
253: BEGIN
254: SELECT 'Y', Template_id
255: INTO l_template_exists, l_template_id
256: FROM pay_element_templates
257: WHERE Template_type = 'T'
258: AND Legislation_code = p_legislation_code
259: AND template_name = 'Flat Amount Deduction';
260: EXCEPTION

Line 289: -- PAY_ELEMENT_TEMPLATES row.

285:
286: l_effective_date := to_date('1901/01/01', 'YYYY/MM/DD');
287:
288: --
289: -- PAY_ELEMENT_TEMPLATES row.
290: --
291: pay_etm_ins.ins
292: (p_template_id => l_template_id
293: ,p_effective_date => l_effective_date

Line 1195: FROM pay_element_templates

1191:
1192: BEGIN
1193: SELECT 'Y', Template_id
1194: INTO l_template_exists, l_template_id
1195: FROM pay_element_templates
1196: WHERE Template_type = 'T'
1197: AND Legislation_code = p_legislation_code
1198: AND template_name = 'Flat Amount';
1199: EXCEPTION

Line 1228: -- PAY_ELEMENT_TEMPLATES row.

1224:
1225: l_effective_date := to_date('1901/01/01', 'YYYY/MM/DD');
1226:
1227: --
1228: -- PAY_ELEMENT_TEMPLATES row.
1229: --
1230: pay_etm_ins.ins
1231: (p_template_id => l_template_id
1232: ,p_effective_date => l_effective_date

Line 1665: FROM pay_element_templates

1661:
1662: BEGIN
1663: SELECT 'Y', Template_id
1664: INTO l_template_exists, l_template_id
1665: FROM pay_element_templates
1666: WHERE Template_type = 'T'
1667: AND Legislation_code = p_legislation_code
1668: AND template_name = 'Hours X Rate';
1669: EXCEPTION

Line 1698: -- PAY_ELEMENT_TEMPLATES row.

1694:
1695: l_effective_date := to_date('1901/01/01', 'YYYY/MM/DD');
1696:
1697: --
1698: -- PAY_ELEMENT_TEMPLATES row.
1699: --
1700: pay_etm_ins.ins
1701: (p_template_id => l_template_id
1702: ,p_effective_date => l_effective_date

Line 2429: FROM pay_element_templates

2425:
2426: BEGIN
2427: SELECT 'Y', Template_id
2428: INTO l_template_exists, l_template_id
2429: FROM pay_element_templates
2430: WHERE Template_type = 'T'
2431: AND Legislation_code = p_legislation_code
2432: AND template_name = 'Percentage Deduction';
2433: EXCEPTION

Line 2462: -- PAY_ELEMENT_TEMPLATES row.

2458:
2459: l_effective_date := to_date('1901/01/01', 'YYYY/MM/DD');
2460:
2461: --
2462: -- PAY_ELEMENT_TEMPLATES row.
2463: --
2464: pay_etm_ins.ins
2465: (p_template_id => l_template_id
2466: ,p_effective_date => l_effective_date

Line 3457: FROM pay_element_templates

3453:
3454: BEGIN
3455: SELECT 'Y', Template_id
3456: INTO l_template_exists, l_template_id
3457: FROM pay_element_templates
3458: WHERE Template_type = 'T'
3459: AND Legislation_code = p_legislation_code
3460: AND template_name = 'Percentage of Earnings';
3461: EXCEPTION

Line 3490: -- PAY_ELEMENT_TEMPLATES row.

3486:
3487: l_effective_date := to_date('1901/01/01', 'YYYY/MM/DD');
3488:
3489: --
3490: -- PAY_ELEMENT_TEMPLATES row.
3491: --
3492: pay_etm_ins.ins
3493: (p_template_id => l_template_id
3494: ,p_effective_date => l_effective_date