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_IE_P45_ARCHIVE dependencies on PER_TIME_PERIOD_TYPES

Line 814: from per_time_period_types tpt

810: -- bi-weekly payroll cutoff and credit and are shown as twice of weekly figures.
811: -- bug 5510536
812: cursor csr_number_per_year (l_period_type per_time_periods.period_type%type) is
813: select number_per_fiscal_year
814: from per_time_period_types tpt
815: where period_type = l_period_type;
816: --
817: l_number_per_year per_time_period_types.number_per_fiscal_year%type;
818:

Line 817: l_number_per_year per_time_period_types.number_per_fiscal_year%type;

813: select number_per_fiscal_year
814: from per_time_period_types tpt
815: where period_type = l_period_type;
816: --
817: l_number_per_year per_time_period_types.number_per_fiscal_year%type;
818:
819: --end vikas
820:
821: -- To display futher PRSI Classes only, if its insurable weeks are non-zero.

Line 2209: per_time_period_types ptpt,

2205: ptp.start_date,
2206: ptp.end_date
2207: from per_all_assignments_f paf,
2208: per_time_periods ptp,
2209: per_time_period_types ptpt,
2210: per_time_period_rules ptpr
2211: where paf.assignment_id = p_assignment_id
2212: and p_date_earned between paf.effective_start_date
2213: and paf.effective_end_date