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_DB_PER_ADDITIONAL dependencies on PAY_PAYROLLS_F

Line 1470: FROM pay_payrolls_f pa

1466: else
1467: hr_utility.set_location('per_db_per_additional.create_employee',34);
1468: SELECT pa.payroll_id
1469: INTO l_payroll_id
1470: FROM pay_payrolls_f pa
1471: WHERE pa.payroll_name = p_payroll
1472: AND pa.business_group_id + 0 = l_business_group_id
1473: AND l_effective_start_date BETWEEN pa.effective_start_date
1474: AND pa.effective_end_date

Line 1476: FROM pay_payrolls_f pa1

1472: AND pa.business_group_id + 0 = l_business_group_id
1473: AND l_effective_start_date BETWEEN pa.effective_start_date
1474: AND pa.effective_end_date
1475: AND l_effective_end_date <= (SELECT max(pa1.effective_end_date)
1476: FROM pay_payrolls_f pa1
1477: WHERE pa1.business_group_id + 0 =
1478: l_business_group_id
1479: AND pa1.payroll_id = pa.payroll_id) ;
1480: end if;

Line 1895: FROM pay_payrolls_f pa

1891: else
1892: hr_utility.set_location('per_db_per_additional.create_secondary_assign',29);
1893: SELECT pa.payroll_id
1894: INTO l_payroll_id
1895: FROM pay_payrolls_f pa
1896: WHERE pa.payroll_name = p_payroll
1897: AND pa.business_group_id + 0 = l_business_group_id
1898: AND l_effective_start_date BETWEEN pa.effective_start_date
1899: AND pa.effective_end_date

Line 1901: FROM pay_payrolls_f pa1

1897: AND pa.business_group_id + 0 = l_business_group_id
1898: AND l_effective_start_date BETWEEN pa.effective_start_date
1899: AND pa.effective_end_date
1900: AND l_effective_end_date <= (SELECT max(pa1.effective_end_date)
1901: FROM pay_payrolls_f pa1
1902: WHERE pa1.business_group_id + 0 =
1903: l_business_group_id
1904: AND pa1.payroll_id = pa.payroll_id) ;
1905: end if;