APPS.PAY_SIMULATOR_SS_PKG dependencies on FND_LOOKUPS

Line 365: l_phase fnd_lookups.meaning%TYPE;

361: from pay_payroll_actions
362: where request_id = p_request_id;
363:
364: l_check_error number;
365: l_phase fnd_lookups.meaning%TYPE;
366: l_status fnd_lookups.meaning%TYPE;
367: l_dev_phase fnd_lookups.meaning%TYPE;
368: l_dev_status fnd_lookups.meaning%TYPE;
369: l_phase_code fnd_lookups.lookup_code%TYPE;

Line 366: l_status fnd_lookups.meaning%TYPE;

362: where request_id = p_request_id;
363:
364: l_check_error number;
365: l_phase fnd_lookups.meaning%TYPE;
366: l_status fnd_lookups.meaning%TYPE;
367: l_dev_phase fnd_lookups.meaning%TYPE;
368: l_dev_status fnd_lookups.meaning%TYPE;
369: l_phase_code fnd_lookups.lookup_code%TYPE;
370: l_status_code fnd_lookups.lookup_code%TYPE;

Line 367: l_dev_phase fnd_lookups.meaning%TYPE;

363:
364: l_check_error number;
365: l_phase fnd_lookups.meaning%TYPE;
366: l_status fnd_lookups.meaning%TYPE;
367: l_dev_phase fnd_lookups.meaning%TYPE;
368: l_dev_status fnd_lookups.meaning%TYPE;
369: l_phase_code fnd_lookups.lookup_code%TYPE;
370: l_status_code fnd_lookups.lookup_code%TYPE;
371: l_check boolean;

Line 368: l_dev_status fnd_lookups.meaning%TYPE;

364: l_check_error number;
365: l_phase fnd_lookups.meaning%TYPE;
366: l_status fnd_lookups.meaning%TYPE;
367: l_dev_phase fnd_lookups.meaning%TYPE;
368: l_dev_status fnd_lookups.meaning%TYPE;
369: l_phase_code fnd_lookups.lookup_code%TYPE;
370: l_status_code fnd_lookups.lookup_code%TYPE;
371: l_check boolean;
372: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;

Line 369: l_phase_code fnd_lookups.lookup_code%TYPE;

365: l_phase fnd_lookups.meaning%TYPE;
366: l_status fnd_lookups.meaning%TYPE;
367: l_dev_phase fnd_lookups.meaning%TYPE;
368: l_dev_status fnd_lookups.meaning%TYPE;
369: l_phase_code fnd_lookups.lookup_code%TYPE;
370: l_status_code fnd_lookups.lookup_code%TYPE;
371: l_check boolean;
372: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
373: l_assignment_set_id pay_payroll_actions.assignment_set_id%type;

Line 370: l_status_code fnd_lookups.lookup_code%TYPE;

366: l_status fnd_lookups.meaning%TYPE;
367: l_dev_phase fnd_lookups.meaning%TYPE;
368: l_dev_status fnd_lookups.meaning%TYPE;
369: l_phase_code fnd_lookups.lookup_code%TYPE;
370: l_status_code fnd_lookups.lookup_code%TYPE;
371: l_check boolean;
372: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
373: l_assignment_set_id pay_payroll_actions.assignment_set_id%type;
374: BEGIN

Line 398: FROM fnd_lookups

394: END IF;
395:
396: SELECT lookup_code
397: INTO l_phase_code
398: FROM fnd_lookups
399: WHERE lookup_type = 'CP_PHASE_CODE'
400: AND meaning = l_phase;
401:
402: SELECT lookup_code

Line 404: FROM fnd_lookups

400: AND meaning = l_phase;
401:
402: SELECT lookup_code
403: INTO l_status_code
404: FROM fnd_lookups
405: WHERE lookup_type = 'CP_STATUS_CODE'
406: AND meaning = l_status;
407:
408: open get_payroll_action_id;