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

Line 520: SELECT START_DATE,end_date FROM per_time_periods WHERE payroll_id=csr_v_payroll_id --3469

516: AND hoi2.org_information_context = 'SE_LOCAL_UNIT_DETAILS';
517:
518: CURSOR csr_payroll_periods(csr_v_effective_date date,csr_v_payroll_id number)
519: IS
520: SELECT START_DATE,end_date FROM per_time_periods WHERE payroll_id=csr_v_payroll_id --3469
521: AND /*'15-jan-2005'*/ csr_v_effective_date BETWEEN START_DATE AND end_date;
522:
523: CURSOR csr_month (csr_v_month NUMBER)
524: IS

Line 1057: SELECT START_DATE,end_date FROM per_time_periods WHERE payroll_id=csr_v_payroll_id --3469

1053: AND hoi2.org_information_context = 'SE_LOCAL_UNIT_DETAILS';
1054:
1055: CURSOR csr_payroll_periods(csr_v_effective_date date,csr_v_payroll_id number)
1056: IS
1057: SELECT START_DATE,end_date FROM per_time_periods WHERE payroll_id=csr_v_payroll_id --3469
1058: AND /*'15-jan-2005'*/ csr_v_effective_date BETWEEN START_DATE AND end_date;
1059:
1060: CURSOR csr_element_types(csr_v_assignment_id number, csr_v_start_date date, csr_v_end_date date,
1061: csr_v_element_type_id number, csr_v_input_value_id number)

Line 1135: FROM per_time_periods ptp,

1131:
1132: CURSOR csr_payroll_period(csr_v_payroll_id number, csr_v_start_date DATE, csr_v_end_date DATE)
1133: IS
1134: SELECT papf.period_type, min(ptp.start_date),min(ptp.end_date)
1135: FROM per_time_periods ptp,
1136: pay_all_payrolls_f papf
1137: WHERE ptp.payroll_id=csr_v_payroll_id --4337 --3469
1138: AND ptp.payroll_id=papf.payroll_id
1139: AND /*'15-jan-2005'*/ ptp.START_DATE >=csr_v_start_date

Line 1254: l_period_start per_time_periods.start_date%TYPE;

1250: l_input_value_id pay_input_values_f.input_value_id%TYPE;
1251: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
1252: l_balance_dimension_id pay_balance_dimensions.balance_dimension_id%TYPE;
1253: l_period per_time_period_types.period_type%TYPE;
1254: l_period_start per_time_periods.start_date%TYPE;
1255: l_period_end per_time_periods.end_date%TYPE;
1256: l_bh_worked_period NUMBER:=0;
1257: l_work_hours_days char(1):='D';
1258: l_payroll_id per_all_assignments_f.payroll_id%TYPE;

Line 1255: l_period_end per_time_periods.end_date%TYPE;

1251: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
1252: l_balance_dimension_id pay_balance_dimensions.balance_dimension_id%TYPE;
1253: l_period per_time_period_types.period_type%TYPE;
1254: l_period_start per_time_periods.start_date%TYPE;
1255: l_period_end per_time_periods.end_date%TYPE;
1256: l_bh_worked_period NUMBER:=0;
1257: l_work_hours_days char(1):='D';
1258: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
1259: