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_KR_DIM_PKG dependencies on PAY_RUN_TYPES_F

Line 495: l_run_type_name pay_run_types_f.run_type_name%TYPE;

491: function run_type_name(p_payroll_action_id IN NUMBER
492: ,p_assact_id IN NUMBER DEFAULT NULL) return VARCHAR2
493: --------------------------------------------------------------------------------
494: is
495: l_run_type_name pay_run_types_f.run_type_name%TYPE;
496: cursor csr_run_type_name is
497: select prt.run_type_name
498: from pay_run_types_f prt,
499: pay_payroll_actions ppa

Line 498: from pay_run_types_f prt,

494: is
495: l_run_type_name pay_run_types_f.run_type_name%TYPE;
496: cursor csr_run_type_name is
497: select prt.run_type_name
498: from pay_run_types_f prt,
499: pay_payroll_actions ppa
500: where ppa.payroll_action_id = p_payroll_action_id
501: and prt.run_type_id = ppa.run_type_id
502: and ppa.effective_date

Line 507: from pay_run_types_f prt,

503: between prt.effective_start_date and prt.effective_end_date;
504:
505: cursor csr_run_type_name_assact is
506: select prt.run_type_name
507: from pay_run_types_f prt,
508: pay_assignment_actions paa,
509: pay_payroll_actions ppa
510: where paa.assignment_action_id = p_assact_id
511: and ppa.payroll_action_id = p_payroll_action_id

Line 547: l_run_type_name pay_run_types_f.run_type_name%TYPE;

543: p_balance_contexts in varchar2,
544: p_feed_flag in out NOCOPY number)
545: --------------------------------------------------------------------------------
546: IS
547: l_run_type_name pay_run_types_f.run_type_name%TYPE;
548: BEGIN
549: l_run_type_name := run_type_name(p_payroll_action_id,p_assignment_action_id);
550: --
551: -- Exclude Separation Payment

Line 571: l_run_type_name pay_run_types_f.run_type_name%TYPE;

567: p_balance_contexts in varchar2,
568: p_feed_flag in out NOCOPY number)
569: --------------------------------------------------------------------------------
570: IS
571: l_run_type_name pay_run_types_f.run_type_name%TYPE;
572: BEGIN
573: l_run_type_name := run_type_name(p_payroll_action_id,p_assignment_action_id);
574: --
575: -- Exclude Separation Payment

Line 594: l_run_type_name pay_run_types_f.run_type_name%TYPE;

590: p_balance_contexts in varchar2,
591: p_feed_flag in out NOCOPY number)
592: --------------------------------------------------------------------------------
593: IS
594: l_run_type_name pay_run_types_f.run_type_name%TYPE;
595: BEGIN
596: l_run_type_name := run_type_name(p_payroll_action_id,p_assignment_action_id);
597: --
598: -- If the run_type is not specified, it is regarded as Monthly Payroll.

Line 619: l_run_type_name pay_run_types_f.run_type_name%TYPE;

615: p_balance_contexts in varchar2,
616: p_feed_flag in out NOCOPY number)
617: --------------------------------------------------------------------------------
618: IS
619: l_run_type_name pay_run_types_f.run_type_name%TYPE;
620: BEGIN
621: l_run_type_name := run_type_name(p_payroll_action_id,p_assignment_action_id);
622: --
623: if l_run_type_name like 'BON\_%' escape '\' then

Line 640: l_run_type_name pay_run_types_f.run_type_name%TYPE;

636: p_balance_contexts in varchar2,
637: p_feed_flag in out NOCOPY number)
638: --------------------------------------------------------------------------------
639: IS
640: l_run_type_name pay_run_types_f.run_type_name%TYPE;
641: BEGIN
642: l_run_type_name := run_type_name(p_payroll_action_id,p_assignment_action_id);
643: --
644: if l_run_type_name in ('SEP','SEP_I') then

Line 659: l_run_type_name pay_run_types_f.run_type_name%TYPE;

655: p_run_type_id in number) return date
656: --------------------------------------------------------------------------------
657: is
658: l_soy constant date := trunc(p_effective_date, 'YYYY');
659: l_run_type_name pay_run_types_f.run_type_name%TYPE;
660: type t_run_type_name_tbl is table of pay_run_types_f.run_type_name%TYPE index by binary_integer;
661: type t_assignment_set_id_tbl is table of number index by binary_integer;
662: type t_start_date_tbl is table of date index by binary_integer;
663: l_run_type_name_tbl t_run_type_name_tbl;

Line 660: type t_run_type_name_tbl is table of pay_run_types_f.run_type_name%TYPE index by binary_integer;

656: --------------------------------------------------------------------------------
657: is
658: l_soy constant date := trunc(p_effective_date, 'YYYY');
659: l_run_type_name pay_run_types_f.run_type_name%TYPE;
660: type t_run_type_name_tbl is table of pay_run_types_f.run_type_name%TYPE index by binary_integer;
661: type t_assignment_set_id_tbl is table of number index by binary_integer;
662: type t_start_date_tbl is table of date index by binary_integer;
663: l_run_type_name_tbl t_run_type_name_tbl;
664: l_assignment_set_id_tbl t_assignment_set_id_tbl;

Line 670: from pay_run_types_f

666: l_bonus_period_start_date date;
667: --
668: cursor csr_run_type_name is
669: select run_type_name
670: from pay_run_types_f
671: where run_type_id = p_run_type_id
672: and p_effective_date
673: between effective_start_date and effective_end_date;
674: --

Line 680: from pay_run_types_f prt,

676: select
677: prt.run_type_name,
678: ppa.assignment_set_id,
679: ptp.start_date
680: from pay_run_types_f prt,
681: per_time_periods ptp,
682: pay_payroll_actions ppa
683: where ppa.payroll_id = p_payroll_id
684: and ppa.action_type = 'R'

Line 793: pay_run_types_f prt2,

789: cursor csr_bonus_period_start_date is
790: select
791: min(greatest(ptp.start_date, trunc(ppa1.effective_date, 'YYYY')))
792: from per_time_periods ptp,
793: pay_run_types_f prt2,
794: pay_payroll_actions ppa2,
795: pay_assignment_actions paa2,
796: pay_run_types_f prt1,
797: pay_payroll_actions ppa1,

Line 796: pay_run_types_f prt1,

792: from per_time_periods ptp,
793: pay_run_types_f prt2,
794: pay_payroll_actions ppa2,
795: pay_assignment_actions paa2,
796: pay_run_types_f prt1,
797: pay_payroll_actions ppa1,
798: pay_assignment_actions paa1
799: where paa1.assignment_action_id = p_assignment_action_id
800: and ppa1.payroll_action_id = paa1.payroll_action_id

Line 819: from pay_run_types_f prt3,

815: and ptp.time_period_id = nvl(ppa2.time_period_id, prt2.run_type_id)
816: and paa2.action_sequence > (
817: /* Latest bonus with same run_type category as corrent bonus. */
818: select nvl(max(paa3.action_sequence), 0)
819: from pay_run_types_f prt3,
820: pay_payroll_actions ppa3,
821: pay_assignment_actions paa3
822: where paa3.assignment_id = paa1.assignment_id
823: and paa3.action_sequence < paa1.action_sequence

Line 897: ,p_bal_asact_rtype_name in pay_run_types_f.run_type_name%type

893: end bonus_period_start_date;
894: --
895: Function inc_or_exc_assact (p_bal_asact in pay_assignment_actions.assignment_action_id%type
896: ,p_asact in pay_assignment_actions.assignment_action_id%type
897: ,p_bal_asact_rtype_name in pay_run_types_f.run_type_name%type
898: ,p_asact_rtype_name in pay_run_types_f.run_type_name%type ) return varchar2 is
899:
900:
901: /* This function is used to arrive at

Line 898: ,p_asact_rtype_name in pay_run_types_f.run_type_name%type ) return varchar2 is

894: --
895: Function inc_or_exc_assact (p_bal_asact in pay_assignment_actions.assignment_action_id%type
896: ,p_asact in pay_assignment_actions.assignment_action_id%type
897: ,p_bal_asact_rtype_name in pay_run_types_f.run_type_name%type
898: ,p_asact_rtype_name in pay_run_types_f.run_type_name%type ) return varchar2 is
899:
900:
901: /* This function is used to arrive at
902: 'Total Taxable Earnings Subj to Regular Tax' for bonus payroll runs .