DBA Data[Home] [Help]

APPS.PAY_IN_ELEMENT_TEMPLATE_PKG dependencies on DUAL

Line 1089: FROM dual;

1085:
1086: pay_in_utils.set_location(g_debug,l_procedure,40);
1087: SELECT pay_ele_tmplt_class_usg_s.nextval
1088: INTO l_ele_tmplt_class_id
1089: FROM dual;
1090:
1091: pay_in_utils.set_location(g_debug,l_procedure,50);
1092: INSERT INTO pay_ele_tmplt_class_usages
1093: ( ele_template_classification_id

Line 1647: FROM dual;

1643:
1644: SELECT DECODE(l_template.configuration_information2,
1645: 'Y','R',l_template.configuration_information2)
1646: INTO l_exp_nature
1647: FROM dual;
1648: ELSE /* IN Actual Expense Allowances */
1649: IF(l_template.configuration_information2 = 'Y') THEN
1650: UPDATE pay_element_templates
1651: SET configuration_information2 = 'N'

Line 1964: FROM dual ;

1960: 'CONFIGURATION_INFORMATION8',l_template.configuration_information8,
1961: 'CONFIGURATION_INFORMATION9',l_template.configuration_information9,
1962: 'CONFIGURATION_INFORMATION10',l_template.configuration_information10)
1963: INTO l_excl_set_value
1964: FROM dual ;
1965: pay_in_utils.trace('l_excl_set_value',l_excl_set_value);
1966:
1967: IF l_excl_set_value = l_excl_def_value THEN
1968: /* if the two values are different, then we need to create the result */