APPS.PAY_SIV_BUS dependencies on PAY_ELEMENT_TEMPLATES

Line 25: , pay_element_templates pet

21: cursor csr_get_element_info is
22: select pet.template_id
23: , pset.input_currency_code
24: from pay_shadow_element_types pset
25: , pay_element_templates pet
26: where pset.element_type_id = p_element_type_id
27: and pet.template_id = pset.template_id;
28: --
29: l_proc varchar2(72) := g_package||'get_element_info';

Line 58: from pay_element_templates pet

54: cursor csr_get_template_info is
55: select pet.business_group_id
56: , pet.legislation_code
57: , pet.template_type
58: from pay_element_templates pet
59: where pet.template_id = p_template_id;
60: --
61: l_proc varchar2(72) := g_package||'get_template_info';
62:

Line 1226: l_business_group_id pay_element_templates.business_group_id%type;

1222: l_proc varchar2(72) := g_package||'insert_validate';
1223: l_template_id number;
1224: l_input_currency_code varchar2(256);
1225:
1226: l_business_group_id pay_element_templates.business_group_id%type;
1227: l_legislation_code pay_element_templates.legislation_code%type;
1228: l_template_type pay_element_templates.template_type%type;
1229:
1230: --

Line 1227: l_legislation_code pay_element_templates.legislation_code%type;

1223: l_template_id number;
1224: l_input_currency_code varchar2(256);
1225:
1226: l_business_group_id pay_element_templates.business_group_id%type;
1227: l_legislation_code pay_element_templates.legislation_code%type;
1228: l_template_type pay_element_templates.template_type%type;
1229:
1230: --
1231: Begin

Line 1228: l_template_type pay_element_templates.template_type%type;

1224: l_input_currency_code varchar2(256);
1225:
1226: l_business_group_id pay_element_templates.business_group_id%type;
1227: l_legislation_code pay_element_templates.legislation_code%type;
1228: l_template_type pay_element_templates.template_type%type;
1229:
1230: --
1231: Begin
1232: hr_utility.set_location('Entering:'||l_proc, 5);

Line 1342: l_business_group_id pay_element_templates.business_group_id%type;

1338: l_proc varchar2(72) := g_package||'update_validate';
1339: l_template_id number;
1340: l_input_currency_code varchar2(256);
1341:
1342: l_business_group_id pay_element_templates.business_group_id%type;
1343: l_legislation_code pay_element_templates.legislation_code%type;
1344: l_template_type pay_element_templates.template_type%type;
1345:
1346: --

Line 1343: l_legislation_code pay_element_templates.legislation_code%type;

1339: l_template_id number;
1340: l_input_currency_code varchar2(256);
1341:
1342: l_business_group_id pay_element_templates.business_group_id%type;
1343: l_legislation_code pay_element_templates.legislation_code%type;
1344: l_template_type pay_element_templates.template_type%type;
1345:
1346: --
1347: Begin

Line 1344: l_template_type pay_element_templates.template_type%type;

1340: l_input_currency_code varchar2(256);
1341:
1342: l_business_group_id pay_element_templates.business_group_id%type;
1343: l_legislation_code pay_element_templates.legislation_code%type;
1344: l_template_type pay_element_templates.template_type%type;
1345:
1346: --
1347: Begin
1348: hr_utility.set_location('Entering:'||l_proc, 5);