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 1648: FROM dual;

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

Line 1965: FROM dual ;

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