eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_SIMULATOR_SS_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 242: FROM pay_payroll_actions ppa

238: CURSOR check_pre_costing
239: (p_start_date IN date
240: , p_end_date IN date) IS
241: SELECT 1
242: FROM pay_payroll_actions ppa
243: , pay_assignment_actions paa
244: WHERE ppa.payroll_action_id = paa.payroll_action_id
245: AND paa.assignment_id = p_assignment_id
246: AND ppa.action_type IN ('C', 'P', 'U')

Line 361: from pay_payroll_actions

357: AND action_context_type = 'ERROR';
358:
359: CURSOR get_payroll_action_id is
360: SELECT payroll_action_id,assignment_set_id
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;

Line 372: l_payroll_action_id pay_payroll_actions.payroll_action_id%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
375:
376: l_check := fnd_concurrent.wait_for_request

Line 373: l_assignment_set_id pay_payroll_actions.assignment_set_id%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
375:
376: l_check := fnd_concurrent.wait_for_request
377: (request_id => p_request_id

Line 571: FROM pay_payroll_actions ppa

567: CURSOR check_pre_costing
568: (p_start_date IN date
569: , p_end_date IN date) IS
570: SELECT 1
571: FROM pay_payroll_actions ppa
572: , pay_assignment_actions paa
573: WHERE ppa.payroll_action_id = paa.payroll_action_id
574: AND paa.assignment_id = p_assignment_id
575: AND ppa.action_type IN ('C', 'P', 'U')

Line 602: select /*+ INDEX (pa2 PAY_PAYROLL_ACTIONS_PK)

598: and l_date_paid between
599: as2.effective_start_date and as2.effective_end_date
600: and pbg.business_group_id = asg.business_group_id
601: and not exists (
602: select /*+ INDEX (pa2 PAY_PAYROLL_ACTIONS_PK)
603: INDEX (ac2 PAY_ASSIGNMENT_ACTIONS_N1) */ null
604: from pay_action_classifications acl,
605: pay_assignment_actions ac2,
606: pay_payroll_actions pa2,

Line 606: pay_payroll_actions pa2,

602: select /*+ INDEX (pa2 PAY_PAYROLL_ACTIONS_PK)
603: INDEX (ac2 PAY_ASSIGNMENT_ACTIONS_N1) */ null
604: from pay_action_classifications acl,
605: pay_assignment_actions ac2,
606: pay_payroll_actions pa2,
607: per_all_assignments_f as2
608: where as2.period_of_service_id = pos.period_of_service_id
609: and ac2.assignment_id = as2.assignment_id
610: and pa2.payroll_action_id = ac2.payroll_action_id