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_PAYROLL_ACTIONS

Line 10: g_payroll_act_id pay_payroll_actions.payroll_action_id%type;

6: g_dbg BOOLEAN := FALSE; --Extra debugging messages
7:
8: g_event_group pay_event_groups.event_group_id%type;
9: g_business_group_id per_business_groups.business_group_id%type;
10: g_payroll_act_id pay_payroll_actions.payroll_action_id%type;
11: g_payroll_id pay_payrolls_f.payroll_id%type;
12: g_asg_set_id hr_assignment_sets.assignment_set_id%type;
13: g_global_env pay_interpreter_pkg.t_global_env_rec;
14: g_adv_flag varchar2(5);

Line 28: l_legparam pay_payroll_actions.legislative_parameters%type;

24: p_report_date out nocopy date)
25: is
26: l_payroll_id number;
27: l_evt_grp_id number;
28: l_legparam pay_payroll_actions.legislative_parameters%type;
29: l_asg_set_name pay_payroll_actions.legislative_parameters%type;
30: l_bus_grp number;
31: l_adv_flag varchar2(1) := 'N';
32: l_report_date date;

Line 29: l_asg_set_name pay_payroll_actions.legislative_parameters%type;

25: is
26: l_payroll_id number;
27: l_evt_grp_id number;
28: l_legparam pay_payroll_actions.legislative_parameters%type;
29: l_asg_set_name pay_payroll_actions.legislative_parameters%type;
30: l_bus_grp number;
31: l_adv_flag varchar2(1) := 'N';
32: l_report_date date;
33: begin

Line 43: from pay_payroll_actions

39: effective_date)
40: into l_legparam,
41: l_bus_grp,
42: l_report_date
43: from pay_payroll_actions
44: where payroll_action_id = pactid;
45: --
46: l_payroll_id := pay_core_utils.get_parameter('PAYROLL_ID', l_legparam);
47: l_asg_set_name := pay_core_utils.get_parameter('ASG_SET', l_legparam)||'_'||pactid;

Line 390: INDEX(PPA PAY_PAYROLL_ACTIONS_PK)

386: p_min DATE,
387: p_max DATE,
388: p_event_group_id number) is
389: SELECT /*+ ORDERED INDEX(PDE PAY_DATETRACKED_EVENTS_UK1)
390: INDEX(PPA PAY_PAYROLL_ACTIONS_PK)
391: USE_NL(PDE)*/
392: DISTINCT
393: prr.source_id entry,
394: pde.datetracked_event_id

Line 396: , pay_payroll_actions ppa

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'
400: AND prr.assignment_action_id = paa.assignment_action_id

Line 432: INDEX(ppa PAY_PAYROLL_ACTIONS_PK)

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,
436: pay_payroll_actions ppa,

Line 436: pay_payroll_actions ppa,

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
440: and paa.action_status not in ('E', 'M', 'U')

Line 457: INDEX(PPA PAY_PAYROLL_ACTIONS_PK)

453: cp_min_ed DATE,
454: cp_max_ed DATE,
455: p_event_group_id number) is
456: SELECT /*+ ORDERED INDEX(PDE PAY_DATETRACKED_EVENTS_UK1)
457: INDEX(PPA PAY_PAYROLL_ACTIONS_PK)
458: USE_NL(PDE)*/
459: DISTINCT
460: prr.source_id entry,
461: prr.element_type_id type,

Line 465: , pay_payroll_actions ppa

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'
469: AND prr.assignment_action_id = paa.assignment_action_id

Line 509: pay_payroll_actions ppa,

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
513: and paa.action_status not in ('E', 'M', 'U')

Line 531: INDEX(PPA PAY_PAYROLL_ACTIONS_PK)

527: cp_max_ed DATE,
528: p_event_group_id number) is
529: SELECT /*+ ORDERED INDEX(PDE PAY_DATETRACKED_EVENTS_UK1)
530: INDEX(PET PAY_ELEMENT_TYPES_F_PK)
531: INDEX(PPA PAY_PAYROLL_ACTIONS_PK)
532: USE_NL(PDE PET)*/
533: DISTINCT
534: prr.source_id entry,
535: pet.element_type_id type,

Line 539: , pay_payroll_actions ppa

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
543: WHERE prr.source_type = 'E'

Line 587: pay_payroll_actions ppa,

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
591: and paa.action_status not in ('E', 'M', 'U')

Line 760: from pay_payroll_actions ppa,

756: select min(effective_date),
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');

Line 911: pay_payroll_actions ppa

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
915: and ppa.action_type in ('R', 'Q');

Line 1049: from pay_payroll_actions ppa,

1045: begin
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 >=

Line 1409: l_legparam pay_payroll_actions.legislative_parameters%type;

1405: --
1406: procedure range_cursor (pactid in number, sqlstr out nocopy varchar2) is
1407: --
1408: l_payroll_id number;
1409: l_legparam pay_payroll_actions.legislative_parameters%type;
1410: l_asg_set_name pay_payroll_actions.legislative_parameters%type;
1411: l_bus_grp number;
1412: l_adv_flag varchar2(1);
1413: --

Line 1410: l_asg_set_name pay_payroll_actions.legislative_parameters%type;

1406: procedure range_cursor (pactid in number, sqlstr out nocopy varchar2) is
1407: --
1408: l_payroll_id number;
1409: l_legparam pay_payroll_actions.legislative_parameters%type;
1410: l_asg_set_name pay_payroll_actions.legislative_parameters%type;
1411: l_bus_grp number;
1412: l_adv_flag varchar2(1);
1413: --
1414: begin

Line 1420: pay_payroll_actions pa1

1416: /* Effective date will be set to sysdate for CC*/
1417: sqlstr := 'select distinct asg.person_id
1418: from
1419: per_assignments_f asg,
1420: pay_payroll_actions pa1
1421: where pa1.payroll_action_id = :payroll_action_id
1422: and asg.payroll_id =
1423: pay_core_utils.get_parameter(''PAYROLL_ID'',
1424: pa1.legislative_parameters)

Line 1433: from pay_payroll_actions

1429: select legislative_parameters,
1430: business_group_id
1431: into l_legparam,
1432: l_bus_grp
1433: from pay_payroll_actions
1434: where payroll_action_id = pactid;
1435: --
1436: l_payroll_id := pay_core_utils.get_parameter('PAYROLL_ID', l_legparam);
1437: l_asg_set_name := pay_core_utils.get_parameter('ASG_SET', l_legparam)||'_'||pactid;

Line 1474: pay_payroll_actions ppa

1470: paf.assignment_id
1471: from
1472: per_periods_of_service pos,
1473: per_assignments_f paf,
1474: pay_payroll_actions ppa
1475: where ppa.payroll_action_id = pactid
1476: and paf.payroll_id =
1477: pay_core_utils.get_parameter('PAYROLL_ID',
1478: ppa.legislative_parameters)

Line 1490: FROM pay_payroll_actions

1486: --
1487: CURSOR c_get_report_type (pactid number) IS
1488:
1489: SELECT report_type
1490: FROM pay_payroll_actions
1491: WHERE payroll_action_id = pactid;
1492: --
1493: CURSOR c_actions_range_on
1494: (

Line 1505: pay_payroll_actions ppa

1501: paf.assignment_id
1502: FROM pay_population_ranges ppr,
1503: per_periods_of_service pos,
1504: per_assignments_f paf,
1505: pay_payroll_actions ppa
1506: where ppa.payroll_action_id = pactid
1507: and paf.payroll_id = pay_core_utils.get_parameter('PAYROLL_ID', ppa.legislative_parameters)
1508: and pos.period_of_service_id = paf.period_of_service_id
1509: and pos.person_id = paf.person_id

Line 1519: l_report_type pay_payroll_actions.report_type%type;

1515: order by paf.assignment_id
1516: for update of paf.assignment_id, pos.period_of_service_id;
1517: --
1518: lockingactid NUMBER;
1519: l_report_type pay_payroll_actions.report_type%type;
1520: l_range_person BOOLEAN; -- 7508169 Variable used to check if RANGE_PERSON_ID is enabled
1521:
1522: --
1523: BEGIN

Line 1649: from pay_payroll_actions pa1

1645: pay_core_utils.get_parameter('GEN_REPORT',
1646: pa1.legislative_parameters)
1647: into remove_act,
1648: l_generate_report
1649: from pay_payroll_actions pa1
1650: where pa1.payroll_action_id = pactid;
1651: --
1652: --
1653: if (l_generate_report is null or l_generate_report = 'Y') then