APPS.PAY_SIV_BUS dependencies on PAY_SHADOW_ELEMENT_TYPES

Line 24: from pay_shadow_element_types pset

20: --
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: --

Line 190: from pay_shadow_element_types pset

186: -- Cursor to check that the element type exists.
187: --
188: cursor csr_element_type_exists is
189: select null
190: from pay_shadow_element_types pset
191: where pset.element_type_id = p_element_type_id;
192: --
193: -- Cursor to count the number of input values that the element type
194: -- already has.

Line 897: from pay_shadow_element_types pset

893: -- consistently.
894: --
895: cursor csr_inconsistent_def_val is
896: select null
897: from pay_shadow_element_types pset
898: , pay_shadow_input_values psiv
899: where pset.template_id = p_template_id
900: and psiv.element_type_id = pset.element_type_id
901: and nvl(upper(psiv.default_value_column), hr_api.g_varchar2) =

Line 1152: from pay_shadow_input_values psiv , pay_shadow_element_types pset

1148: and sf.formula_type_name = pay_sf_shd.g_input_val_formula_type
1149: and sf.business_group_id = p_business_group_id
1150: and not exists
1151: (select null
1152: from pay_shadow_input_values psiv , pay_shadow_element_types pset
1153: where psiv.formula_id = p_formula_id
1154: and pset.element_type_id = psiv.element_type_id
1155: and pset.template_id <> p_template_id);
1156: --