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 PAY_ALL_PAYROLLS_F

Line 563: from pay_all_payrolls_f prl

559: PET.EFFECTIVE_END_DATE;
560:
561: CURSOR payroll is
562: select tpt.number_per_fiscal_year
563: from pay_all_payrolls_f prl
564: , per_all_assignments_f paf
565: , per_time_period_types tpt
566: where paf.assignment_id=p_assignment_id
567: and p_effective_date between paf.effective_start_date

Line 682: from pay_all_payrolls_f pap

678: where lookup_type = p_lookup_type
679: and lookup_code = p_lookup_code;
680: cursor csr_table is
681: select description
682: from pay_all_payrolls_f pap
683: ,per_all_assignments_f paa
684: ,hr_lookups
685: where pap.payroll_id = paa.payroll_id
686: and paa.assignment_id = p_assignment_id

Line 693: ,pay_all_payrolls_f pap

689: and lookup_type = 'PROC_PERIOD_TYPE';
690: cursor csr_period_table is
691: select nvl(DESCRIPTION,ptt.period_type)
692: from PER_TIME_PERIOD_TYPES ptt
693: ,pay_all_payrolls_f pap
694: ,per_all_assignments_f paa
695: where pap.payroll_id = paa.payroll_id
696: and paa.assignment_id = p_assignment_id
697: and p_effective_date between paa.effective_start_date and paa.effective_end_date

Line 721: l_dummy pay_all_payrolls_f.payroll_name%type;

717:
718: FUNCTION get_pay_annualization_factor (p_assignment_id IN NUMBER, p_effective_date IN DATE, p_annualization_factor IN NUMBER, p_pay_basis IN VARCHAR2)
719: return NUMBER
720: is
721: l_dummy pay_all_payrolls_f.payroll_name%type;
722: l_annualization_factor NUMBER(20);
723: Begin
724: l_annualization_factor := p_annualization_factor;
725: if(p_pay_basis ='PERIOD' and l_annualization_factor is null) then

Line 1279: from pay_all_payrolls_f prl ,

1275: AND p_effective_date BETWEEN PET.EFFECTIVE_START_DATE AND PET.EFFECTIVE_END_DATE;
1276: --
1277: Cursor csr_payroll_freq is
1278: select tpt.number_per_fiscal_year
1279: from pay_all_payrolls_f prl ,
1280: per_time_period_types tpt
1281: where prl.payroll_id = p_curr_payroll_id
1282: and p_effective_date between prl.effective_start_date and prl.effective_end_date
1283: and prl.period_type = tpt.period_type(+);