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

Line 1061: FROM per_time_periods

1057: ,prd_information4
1058: ,prd_information6
1059: ,prd_information8
1060: ,prd_information9
1061: FROM per_time_periods
1062: WHERE payroll_id = p_payroll_id
1063: AND p_date_earned BETWEEN start_date AND end_date;
1064:
1065: lr_further_period_details csr_further_period_details%ROWTYPE;

Line 1331: FROM per_time_periods

1327:
1328: CURSOR csr_further_period_details
1329: IS
1330: SELECT prd_information4
1331: FROM per_time_periods
1332: WHERE payroll_id = p_payroll_id
1333: AND p_effective_date BETWEEN start_date AND end_date;
1334:
1335: CURSOR csr_earning_year

Line 1477: FROM per_time_periods

1473: ,prd_information4
1474: ,prd_information5
1475: ,prd_information7
1476: ,prd_information8
1477: FROM per_time_periods
1478: WHERE payroll_id = p_payroll_id
1479: AND p_date_earned BETWEEN start_date AND end_date;
1480:
1481: lr_further_period_details csr_further_period_details%ROWTYPE;

Line 2294: FROM per_time_periods

2290:
2291: CURSOR csr_first_payroll_start_date (v_payroll_id NUMBER, v_date DATE)
2292: IS
2293: SELECT MIN (start_date)
2294: FROM per_time_periods
2295: WHERE payroll_id = v_payroll_id AND start_date >= v_date;
2296: BEGIN
2297: l_business_group_id := p_business_group_id;
2298: