APPS.PAY_SIMULATOR_SS_PKG dependencies on PAY_SIMULATION_INFORMATION

Line 37: DELETE FROM pay_simulation_information

33: (p_assignment_id IN NUMBER)
34: is
35: begin
36:
37: DELETE FROM pay_simulation_information
38: WHERE assignment_id = p_assignment_id
39: AND ACTION_CONTEXT_TYPE = 'ERROR';
40:
41:

Line 355: FROM pay_simulation_information

351: , p_error_type OUT nocopy varchar2
352: , p_error_message OUT nocopy varchar2) IS
353: CURSOR c_check_error IS
354: SELECT 1
355: FROM pay_simulation_information
356: WHERE assignment_id = p_assignment_id
357: AND action_context_type = 'ERROR';
358:
359: CURSOR get_payroll_action_id is

Line 686: from pay_simulation_information

682:
683: cursor c_input_name
684: is
685: select ACTION_INFORMATION1
686: from pay_simulation_information
687: where assignment_id = p_assignment_id
688: and ACTION_CONTEXT_TYPE = 'INPUTSLOV'
689: and ACTION_INFORMATION3 = to_char(p_input_value_id);
690:

Line 691: l_name pay_simulation_information.ACTION_INFORMATION1%type;

687: where assignment_id = p_assignment_id
688: and ACTION_CONTEXT_TYPE = 'INPUTSLOV'
689: and ACTION_INFORMATION3 = to_char(p_input_value_id);
690:
691: l_name pay_simulation_information.ACTION_INFORMATION1%type;
692: l_uom pay_input_values_f.uom%TYPE;
693: --
694: l_lookup_type pay_input_values_f.lookup_type%TYPE;
695: l_value_set_id pay_input_values_f.value_set_id%TYPE;