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_CORE_UPGRADE_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 529: from pay_element_types_f pet,

525: --
526: begin
527: select distinct pet.element_type_id
528: into l_src_et_id
529: from pay_element_types_f pet,
530: pay_element_links_f pel,
531: pay_element_entries_f pee
532: where pee.element_entry_id = l_src_entry_id
533: and pee.element_link_id = pel.element_link_id

Line 546: from pay_element_types_f

542: l_retro_et_cnt number;
543: begin
544: select count(distinct(element_type_id))
545: into l_retro_et_cnt
546: from pay_element_types_f
547: where retro_summ_ele_id = eerec.element_type_id;
548: --
549: if (l_retro_et_cnt = 0) then
550: l_src_et_id := eerec.element_type_id;

Line 554: from pay_element_types_f

550: l_src_et_id := eerec.element_type_id;
551: elsif (l_retro_et_cnt = 1) then
552: select distinct(element_type_id)
553: into l_src_et_id
554: from pay_element_types_f
555: where retro_summ_ele_id = eerec.element_type_id;
556: else
557: --pay_core_utils.assert_condition(
558: -- 'upg_retro_proc_det_frm_ee:8',

Line 564: from pay_element_types_f

560: --
561: -- Since there can be many then take the first one.
562: select distinct(element_type_id)
563: into l_src_et_id
564: from pay_element_types_f
565: where retro_summ_ele_id = eerec.element_type_id
566: and rownum = 1;
567: end if;
568: --

Line 584: from pay_element_types_f

580: l_retro_et_cnt number;
581: begin
582: select count(distinct(element_type_id))
583: into l_retro_et_cnt
584: from pay_element_types_f
585: where retro_summ_ele_id = eerec.element_type_id;
586: --
587: if (l_retro_et_cnt = 0) then
588: l_src_et_id := eerec.element_type_id;

Line 592: from pay_element_types_f

588: l_src_et_id := eerec.element_type_id;
589: else
590: select distinct element_type_id
591: into l_src_et_id
592: from pay_element_types_f
593: where retro_summ_ele_id = eerec.element_type_id
594: and rownum = 1;
595: end if;
596: end;

Line 684: from pay_element_types_f pet,

680: --
681: begin
682: select distinct pet.element_type_id
683: into l_src_et_id
684: from pay_element_types_f pet,
685: pay_element_links_f pel,
686: pay_element_entries_f pee
687: where pee.element_entry_id = l_src_entry_id
688: and pee.element_link_id = pel.element_link_id

Line 701: from pay_element_types_f

697: l_retro_et_cnt number;
698: begin
699: select count(distinct(element_type_id))
700: into l_retro_et_cnt
701: from pay_element_types_f
702: where retro_summ_ele_id = eerec.element_type_id;
703: -- and element_type_id = l_src_et_id;
704: --
705: if (l_retro_et_cnt = 0) then

Line 710: from pay_element_types_f

706: l_src_et_id := eerec.element_type_id;
707: elsif (l_retro_et_cnt = 1) then
708: select distinct(element_type_id)
709: into l_src_et_id
710: from pay_element_types_f
711: where retro_summ_ele_id = eerec.element_type_id;
712: -- and element_type_id = l_src_et_id;
713: else
714: -- pay_core_utils.assert_condition(

Line 721: from pay_element_types_f

717: --
718: -- Since there can be many then take the first one.
719: select distinct(element_type_id)
720: into l_src_et_id
721: from pay_element_types_f
722: where retro_summ_ele_id = eerec.element_type_id
723: and rownum = 1;
724: end if;
725: --

Line 741: from pay_element_types_f

737: l_retro_et_cnt number;
738: begin
739: select count(distinct(element_type_id))
740: into l_retro_et_cnt
741: from pay_element_types_f
742: where retro_summ_ele_id = eerec.element_type_id;
743: --
744: if (l_retro_et_cnt = 0) then
745: l_src_et_id := eerec.element_type_id;

Line 749: from pay_element_types_f

745: l_src_et_id := eerec.element_type_id;
746: else
747: select distinct element_type_id
748: into l_src_et_id
749: from pay_element_types_f
750: where retro_summ_ele_id = eerec.element_type_id
751: and rownum = 1;
752: end if;
753: end;

Line 889: ET PAY_ELEMENT_TYPES_F_PK)

885: SELECT /*+ ORDERED
886: USE_NL (ASGT_ACTION, EE, ET)
887: INDEX(
888: EE PAY_ELEMENT_ENTRIES_F_N50,
889: ET PAY_ELEMENT_TYPES_F_PK)
890: */
891: DISTINCT ASGT_ACTION.assignment_action_id, EE.element_entry_id
892: FROM pay_assignment_actions ASGT_ACTION,
893: pay_payroll_actions PAY_ACTION,

Line 895: pay_element_types_f ET

891: DISTINCT ASGT_ACTION.assignment_action_id, EE.element_entry_id
892: FROM pay_assignment_actions ASGT_ACTION,
893: pay_payroll_actions PAY_ACTION,
894: pay_element_entries_f EE,
895: pay_element_types_f ET
896: WHERE ASGT_ACTION.assignment_id = p_asg_id
897: AND ASGT_ACTION.payroll_action_id = PAY_ACTION.payroll_action_id
898: AND PAY_ACTION.action_type = 'Q'
899: AND ASGT_ACTION.source_action_id is null

Line 1375: pay_element_types_f pet

1371: pay_entry_process_details pepd,
1372: pay_assignment_actions paa,
1373: pay_payroll_actions ppa,
1374: per_time_periods ptp,
1375: pay_element_types_f pet
1376: where pee.creator_type in ('RR', 'EE')
1377: and pee.assignment_id = p_asg_id
1378: and pee.element_entry_id = pepd.element_entry_id
1379: and pepd.source_asg_action_id = paa.assignment_action_id

Line 1401: pay_element_types_f pet,

1397: ppa.action_type
1398: from
1399: pay_assignment_actions paa,
1400: pay_payroll_actions ppa,
1401: pay_element_types_f pet,
1402: pay_run_results prr
1403: where paa.assignment_id = p_asg_id
1404: and paa.assignment_action_id = prr.assignment_action_id
1405: and ppa.payroll_action_id = paa.payroll_action_id