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.HR_AMEUTIL_SS dependencies on PER_ALL_ASSIGNMENTS_F

Line 2209: l_assignment_id per_all_assignments_f.assignment_id%type default null;

2205: lv_status varchar2(10);
2206: result varchar2(50);
2207:
2208:
2209: l_assignment_id per_all_assignments_f.assignment_id%type default null;
2210: l_payroll_id per_all_assignments_f.payroll_id%type default null;
2211: l_old_pay_basis_id per_all_assignments_f.pay_basis_id%type default null;
2212: l_new_pay_basis_id per_all_assignments_f.pay_basis_id%type default null;
2213: l_pay_period_start_date date default null;

Line 2210: l_payroll_id per_all_assignments_f.payroll_id%type default null;

2206: result varchar2(50);
2207:
2208:
2209: l_assignment_id per_all_assignments_f.assignment_id%type default null;
2210: l_payroll_id per_all_assignments_f.payroll_id%type default null;
2211: l_old_pay_basis_id per_all_assignments_f.pay_basis_id%type default null;
2212: l_new_pay_basis_id per_all_assignments_f.pay_basis_id%type default null;
2213: l_pay_period_start_date date default null;
2214: l_pay_period_end_date date default null;

Line 2211: l_old_pay_basis_id per_all_assignments_f.pay_basis_id%type default null;

2207:
2208:
2209: l_assignment_id per_all_assignments_f.assignment_id%type default null;
2210: l_payroll_id per_all_assignments_f.payroll_id%type default null;
2211: l_old_pay_basis_id per_all_assignments_f.pay_basis_id%type default null;
2212: l_new_pay_basis_id per_all_assignments_f.pay_basis_id%type default null;
2213: l_pay_period_start_date date default null;
2214: l_pay_period_end_date date default null;
2215:

Line 2212: l_new_pay_basis_id per_all_assignments_f.pay_basis_id%type default null;

2208:
2209: l_assignment_id per_all_assignments_f.assignment_id%type default null;
2210: l_payroll_id per_all_assignments_f.payroll_id%type default null;
2211: l_old_pay_basis_id per_all_assignments_f.pay_basis_id%type default null;
2212: l_new_pay_basis_id per_all_assignments_f.pay_basis_id%type default null;
2213: l_pay_period_start_date date default null;
2214: l_pay_period_end_date date default null;
2215:
2216: l_asg_txn_step_id hr_api_transaction_steps.transaction_step_id%type

Line 2232: FROM per_all_assignments_f

2228:
2229: -- Get existing assignment data
2230: CURSOR csr_get_old_asg_data IS
2231: SELECT pay_basis_id
2232: FROM per_all_assignments_f
2233: WHERE assignment_id = l_assignment_id
2234: AND l_effective_date between effective_start_date
2235: and effective_end_date
2236: AND assignment_type = 'E';

Line 2330: from per_all_assignments_f paf,

2326:
2327:
2328: cursor requestorPosId is
2329: select paf.position_id
2330: from per_all_assignments_f paf,
2331: per_all_people_f ppf,
2332: per_position_structures pps, per_pos_structure_versions ppsv,
2333: hr_api_transactions hat
2334: where hat.transaction_id = p_transaction_id