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 540: FROM pay_assignment_actions paa

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

Line 588: from pay_assignment_actions paa,

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

Line 777: pay_assignment_actions paa

773: from (
774: select min(date_earned) min_date,
775: ppa.payroll_id payroll_id
776: from pay_payroll_actions ppa,
777: pay_assignment_actions paa
778: where paa.assignment_id = p_assignment_id
779: and paa.payroll_action_id = ppa.payroll_action_id
780: and ppa.action_type in ('Q', 'R', 'B', 'V')
781: group by payroll_id

Line 803: pay_assignment_actions paa

799: from (
800: select min(effective_date) min_date,
801: ppa.payroll_id payroll_id
802: from pay_payroll_actions ppa,
803: pay_assignment_actions paa
804: where paa.assignment_id = p_assignment_id
805: and paa.payroll_action_id = ppa.payroll_action_id
806: and ppa.action_type in ('Q', 'R', 'B', 'V')
807: group by payroll_id

Line 975: from pay_assignment_actions paa,

971: select max(ppa.date_earned),
972: max(ppa.effective_date)
973: into l_max_ppa_de_date,
974: l_max_ppa_eff_date
975: from pay_assignment_actions paa,
976: pay_payroll_actions ppa
977: where paa.assignment_id = p_assignment_id
978: and paa.action_status not in ('U', 'M', 'E')
979: and ppa.payroll_action_id = paa.payroll_action_id

Line 1115: pay_assignment_actions paa

1111: --
1112: select min(ppa.effective_date)
1113: into l_reprocess_date
1114: from pay_payroll_actions ppa,
1115: pay_assignment_actions paa
1116: where ppa.payroll_action_id = paa.payroll_action_id
1117: and paa.assignment_id = p_assignment_id
1118: and ppa.date_earned >=
1119: l_detailed_output(cnt).effective_date

Line 1355: l_asg_id pay_assignment_actions.assignment_id%type;

1351: --
1352: procedure process_action(p_assactid in number, p_effective_date in date)
1353: is
1354: --
1355: l_asg_id pay_assignment_actions.assignment_id%type;
1356: --
1357: begin
1358: --
1359: hr_utility.trace('In process_action');

Line 1363: from pay_assignment_actions

1359: hr_utility.trace('In process_action');
1360:
1361: select assignment_id
1362: into l_asg_id
1363: from pay_assignment_actions
1364: where assignment_action_id = p_assactid;
1365: --
1366: generate_dates_and_process(l_asg_id);
1367: --

Line 1613: SELECT pay_assignment_actions_s.nextval

1609: END if;
1610:
1611: for asgrec in c_actions_range_on(pactid, chunk) loop
1612: --
1613: SELECT pay_assignment_actions_s.nextval
1614: INTO lockingactid
1615: FROM dual;
1616: --
1617: -- insert the action record.

Line 1630: SELECT pay_assignment_actions_s.nextval

1626: END if;
1627:
1628: for asgrec in c_actions(pactid, stperson, endperson) loop
1629: --
1630: SELECT pay_assignment_actions_s.nextval
1631: INTO lockingactid
1632: FROM dual;
1633: --
1634: -- insert the action record.