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_RETRO_NOTIF_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 395: FROM pay_assignment_actions paa

391: USE_NL(PDE)*/
392: DISTINCT
393: prr.source_id entry,
394: pde.datetracked_event_id
395: FROM pay_assignment_actions paa
396: , pay_payroll_actions ppa
397: , pay_run_results prr
398: , pay_datetracked_events pde
399: WHERE prr.source_type = 'E'

Line 431: AND exists (select /*+ ORDERED INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)

427: /* Make sure that the Entry is not a Retropay Entry */
428: AND nvl(pee.creator_type, 'F') not in ('EE', 'RR', 'PR', 'NR')
429: AND pee.effective_start_date <= p_max
430: AND pee.effective_end_date >= p_min
431: AND exists (select /*+ ORDERED INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)
432: INDEX(ppa PAY_PAYROLL_ACTIONS_PK)
433: USE_NL(paa ppa) */
434: ''
435: from pay_assignment_actions paa,

Line 435: from pay_assignment_actions paa,

431: AND exists (select /*+ ORDERED INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)
432: INDEX(ppa PAY_PAYROLL_ACTIONS_PK)
433: USE_NL(paa ppa) */
434: ''
435: from pay_assignment_actions paa,
436: pay_payroll_actions ppa,
437: per_time_periods ptp
438: where ppa.payroll_action_id = paa.payroll_action_id
439: and paa.assignment_id = pee.assignment_id

Line 464: FROM pay_assignment_actions paa

460: prr.source_id entry,
461: prr.element_type_id type,
462: pde.datetracked_event_id,
463: p_event_group_id
464: FROM pay_assignment_actions paa
465: , pay_payroll_actions ppa
466: , pay_run_results prr
467: , pay_datetracked_events pde
468: WHERE prr.source_type = 'E'

Line 508: from pay_assignment_actions paa,

504: AND nvl(pee.creator_type, 'F') not in ('EE', 'RR', 'PR', 'NR')
505: AND pee.effective_start_date <= cp_max_ed
506: AND pee.effective_end_date >= cp_min_ed
507: AND exists (select ''
508: from pay_assignment_actions paa,
509: pay_payroll_actions ppa,
510: per_time_periods ptp
511: where ppa.payroll_action_id = paa.payroll_action_id
512: and paa.assignment_id = pee.assignment_id

Line 538: FROM pay_assignment_actions paa

534: prr.source_id entry,
535: pet.element_type_id type,
536: pde.datetracked_event_id,
537: nvl(pet.recalc_event_group_id, -1) event_group_id
538: FROM pay_assignment_actions paa
539: , pay_payroll_actions ppa
540: , pay_run_results prr
541: , pay_element_types_f pet
542: , pay_datetracked_events pde

Line 586: from pay_assignment_actions paa,

582: AND nvl(pee.creator_type, 'F') not in ('EE', 'RR', 'PR', 'NR')
583: AND pee.effective_start_date <= cp_max_ed
584: AND pee.effective_end_date >= cp_min_ed
585: AND exists (select ''
586: from pay_assignment_actions paa,
587: pay_payroll_actions ppa,
588: per_time_periods ptp
589: where ppa.payroll_action_id = paa.payroll_action_id
590: and paa.assignment_id = pee.assignment_id

Line 761: pay_assignment_actions paa

757: min(date_earned)
758: into l_min_run_eff_date,
759: l_min_run_ear_date
760: from pay_payroll_actions ppa,
761: pay_assignment_actions paa
762: where paa.assignment_id = p_assignment_id
763: and paa.payroll_action_id = ppa.payroll_action_id
764: and ppa.action_type in ('Q', 'R', 'B', 'V');
765: --

Line 910: from pay_assignment_actions paa,

906: select max(ppa.date_earned),
907: max(ppa.effective_date)
908: into l_max_ppa_de_date,
909: l_max_ppa_eff_date
910: from pay_assignment_actions paa,
911: pay_payroll_actions ppa
912: where paa.assignment_id = p_assignment_id
913: and paa.action_status not in ('U', 'M', 'E')
914: and ppa.payroll_action_id = paa.payroll_action_id

Line 1050: pay_assignment_actions paa

1046: --
1047: select min(ppa.effective_date)
1048: into l_reprocess_date
1049: from pay_payroll_actions ppa,
1050: pay_assignment_actions paa
1051: where ppa.payroll_action_id = paa.payroll_action_id
1052: and paa.assignment_id = p_assignment_id
1053: and ppa.date_earned >=
1054: l_detailed_output(cnt).effective_date

Line 1290: l_asg_id pay_assignment_actions.assignment_id%type;

1286: --
1287: procedure process_action(p_assactid in number, p_effective_date in date)
1288: is
1289: --
1290: l_asg_id pay_assignment_actions.assignment_id%type;
1291: --
1292: begin
1293: --
1294: hr_utility.trace('In process_action');

Line 1298: from pay_assignment_actions

1294: hr_utility.trace('In process_action');
1295:
1296: select assignment_id
1297: into l_asg_id
1298: from pay_assignment_actions
1299: where assignment_action_id = p_assactid;
1300: --
1301: generate_dates_and_process(l_asg_id);
1302: --

Line 1548: SELECT pay_assignment_actions_s.nextval

1544: END if;
1545:
1546: for asgrec in c_actions_range_on(pactid, chunk) loop
1547: --
1548: SELECT pay_assignment_actions_s.nextval
1549: INTO lockingactid
1550: FROM dual;
1551: --
1552: -- insert the action record.

Line 1565: SELECT pay_assignment_actions_s.nextval

1561: END if;
1562:
1563: for asgrec in c_actions(pactid, stperson, endperson) loop
1564: --
1565: SELECT pay_assignment_actions_s.nextval
1566: INTO lockingactid
1567: FROM dual;
1568: --
1569: -- insert the action record.