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

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

Line 589: pay_payroll_actions ppa,

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

Line 776: from pay_payroll_actions ppa,

772: l_payroll_id_ear_date
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')

Line 802: from pay_payroll_actions ppa,

798: l_payroll_id_eff_date
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')

Line 976: pay_payroll_actions ppa

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

Line 1114: from pay_payroll_actions ppa,

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

Line 1474: l_legparam pay_payroll_actions.legislative_parameters%type;

1470: --
1471: procedure range_cursor (pactid in number, sqlstr out nocopy varchar2) is
1472: --
1473: l_payroll_id number;
1474: l_legparam pay_payroll_actions.legislative_parameters%type;
1475: l_asg_set_name pay_payroll_actions.legislative_parameters%type;
1476: l_bus_grp number;
1477: l_adv_flag varchar2(1);
1478: --

Line 1475: l_asg_set_name pay_payroll_actions.legislative_parameters%type;

1471: procedure range_cursor (pactid in number, sqlstr out nocopy varchar2) is
1472: --
1473: l_payroll_id number;
1474: l_legparam pay_payroll_actions.legislative_parameters%type;
1475: l_asg_set_name pay_payroll_actions.legislative_parameters%type;
1476: l_bus_grp number;
1477: l_adv_flag varchar2(1);
1478: --
1479: begin

Line 1485: pay_payroll_actions pa1

1481: /* Effective date will be set to sysdate for CC*/
1482: sqlstr := 'select distinct asg.person_id
1483: from
1484: per_assignments_f asg,
1485: pay_payroll_actions pa1
1486: where pa1.payroll_action_id = :payroll_action_id
1487: and asg.payroll_id =
1488: pay_core_utils.get_parameter(''PAYROLL_ID'',
1489: pa1.legislative_parameters)

Line 1498: from pay_payroll_actions

1494: select legislative_parameters,
1495: business_group_id
1496: into l_legparam,
1497: l_bus_grp
1498: from pay_payroll_actions
1499: where payroll_action_id = pactid;
1500: --
1501: l_payroll_id := pay_core_utils.get_parameter('PAYROLL_ID', l_legparam);
1502: l_asg_set_name := pay_core_utils.get_parameter('ASG_SET', l_legparam)||'_'||pactid;

Line 1539: pay_payroll_actions ppa

1535: paf.assignment_id
1536: from
1537: per_periods_of_service pos,
1538: per_assignments_f paf,
1539: pay_payroll_actions ppa
1540: where ppa.payroll_action_id = pactid
1541: and paf.payroll_id =
1542: pay_core_utils.get_parameter('PAYROLL_ID',
1543: ppa.legislative_parameters)

Line 1555: FROM pay_payroll_actions

1551: --
1552: CURSOR c_get_report_type (pactid number) IS
1553:
1554: SELECT report_type
1555: FROM pay_payroll_actions
1556: WHERE payroll_action_id = pactid;
1557: --
1558: CURSOR c_actions_range_on
1559: (

Line 1570: pay_payroll_actions ppa

1566: paf.assignment_id
1567: FROM pay_population_ranges ppr,
1568: per_periods_of_service pos,
1569: per_assignments_f paf,
1570: pay_payroll_actions ppa
1571: where ppa.payroll_action_id = pactid
1572: and paf.payroll_id = pay_core_utils.get_parameter('PAYROLL_ID', ppa.legislative_parameters)
1573: and pos.period_of_service_id = paf.period_of_service_id
1574: and pos.person_id = paf.person_id

Line 1584: l_report_type pay_payroll_actions.report_type%type;

1580: order by paf.assignment_id
1581: for update of paf.assignment_id, pos.period_of_service_id;
1582: --
1583: lockingactid NUMBER;
1584: l_report_type pay_payroll_actions.report_type%type;
1585: l_range_person BOOLEAN; -- 7508169 Variable used to check if RANGE_PERSON_ID is enabled
1586:
1587: --
1588: BEGIN

Line 1714: from pay_payroll_actions pa1

1710: pay_core_utils.get_parameter('GEN_REPORT',
1711: pa1.legislative_parameters)
1712: into remove_act,
1713: l_generate_report
1714: from pay_payroll_actions pa1
1715: where pa1.payroll_action_id = pactid;
1716: --
1717: --
1718: if (l_generate_report is null or l_generate_report = 'Y') then