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.PER_SALADMIN_UTILITY dependencies on PER_TIME_PERIOD_TYPES

Line 534: , per_time_period_types tpt

530: CURSOR payroll is
531: select tpt.number_per_fiscal_year
532: from pay_all_payrolls_f prl
533: , per_all_assignments_f paf
534: , per_time_period_types tpt
535: where paf.assignment_id=p_assignment_id
536: and p_effective_date between paf.effective_start_date
537: and paf.effective_end_date
538: and paf.payroll_id=prl.payroll_id

Line 661: from PER_TIME_PERIOD_TYPES ptt

657: and meaning = pap.period_type
658: and lookup_type = 'PROC_PERIOD_TYPE';
659: cursor csr_period_table is
660: select nvl(DESCRIPTION,ptt.period_type)
661: from PER_TIME_PERIOD_TYPES ptt
662: ,pay_all_payrolls_f pap
663: ,per_all_assignments_f paa
664: where pap.payroll_id = paa.payroll_id
665: and paa.assignment_id = p_assignment_id

Line 1055: per_time_period_types tpt

1051: --
1052: Cursor csr_payroll_freq is
1053: select tpt.number_per_fiscal_year
1054: from pay_all_payrolls_f prl ,
1055: per_time_period_types tpt
1056: where prl.payroll_id = p_curr_payroll_id
1057: and p_effective_date between prl.effective_start_date and prl.effective_end_date
1058: and prl.period_type = tpt.period_type(+);
1059: --