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_ZA_EMP201 dependencies on PER_TIME_PERIODS

Line 678: per_time_periods ptp

674: , ppa.payroll_id
675: , ptp.end_date
676: from pay_assignment_actions paa,
677: pay_payroll_actions ppa,
678: per_time_periods ptp
679: where paa.assignment_id = p_assignment_id
680: and paa.payroll_action_id = ppa.payroll_action_id
681: and ppa.action_type IN ('R', 'Q', 'V', 'B', 'I')
682: and paa.action_status IN ('C','S') -- 10376999

Line 689: per_time_periods ptp1

685: and ptp.pay_advice_date between trunc(l_effective_date,'Month') and l_effective_date
686: and paa.action_sequence = (select max(paa1.action_sequence)
687: from pay_assignment_actions paa1,
688: pay_payroll_actions ppa1,
689: per_time_periods ptp1
690: where paa1.assignment_id = p_assignment_id
691: and paa1.payroll_action_id = ppa1.payroll_action_id
692: and ppa1.action_type IN ('R', 'Q', 'V', 'B', 'I')
693: and paa1.action_status IN ('C','S') -- 10376999

Line 720: from per_time_periods ptp

716: --Its same query used for route ZA_PAY_MONTH_PERIOD_NUMBER
717: cursor csr_za_pay_mnth_prd_num (p_payroll_action_id number
718: , p_payroll_id number) is
719: select count(ptp.end_date)
720: from per_time_periods ptp
721: where ptp.pay_advice_date =
722: (select tperiod.pay_advice_date
723: from per_time_periods tperiod,
724: pay_payroll_actions paction

Line 723: from per_time_periods tperiod,

719: select count(ptp.end_date)
720: from per_time_periods ptp
721: where ptp.pay_advice_date =
722: (select tperiod.pay_advice_date
723: from per_time_periods tperiod,
724: pay_payroll_actions paction
725: where paction.payroll_action_id = p_payroll_action_id
726: and tperiod.time_period_id = paction.time_period_id
727: )

Line 730: from per_time_periods tperiod,

726: and tperiod.time_period_id = paction.time_period_id
727: )
728: and ptp.end_date <=
729: (select tperiod.end_date
730: from per_time_periods tperiod,
731: pay_payroll_actions paction
732: where paction.payroll_action_id = p_payroll_action_id
733: and tperiod.time_period_id = paction.time_period_id
734: )

Line 742: from per_time_periods PTP

738: --Its same query used for route ZA_PAY_PERIODS_PER_YEAR
739: cursor csr_pay_prd_per_yr (p_payroll_action_id number
740: , p_payroll_id number) is
741: select count(ptp.end_date)
742: from per_time_periods PTP
743: where ptp.prd_information1 =
744: (select tperiod.prd_information1
745: from per_time_periods tperiod,
746: pay_payroll_actions paction

Line 745: from per_time_periods tperiod,

741: select count(ptp.end_date)
742: from per_time_periods PTP
743: where ptp.prd_information1 =
744: (select tperiod.prd_information1
745: from per_time_periods tperiod,
746: pay_payroll_actions paction
747: where paction.payroll_action_id = p_payroll_action_id
748: and tperiod.time_period_id = paction.time_period_id)
749: and ptp.payroll_id = p_payroll_id;

Line 823: per_time_periods ptp

819: is
820: select paa.assignment_action_id assignment_action_id
821: from pay_assignment_actions paa,
822: pay_payroll_actions ppa,
823: per_time_periods ptp
824: where paa.assignment_id = p_assignment_id
825: and paa.action_status IN ('C','S')
826: and paa.payroll_action_id = ppa.payroll_action_id
827: and ppa.action_type = 'V'