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_CN_SOE dependencies on PER_ASSIGNMENTS_F

Line 225: , per_assignments_f paf

221: CURSOR csr_get_tax_unit_id
222: IS
223: SELECT hsck.segment1
224: FROM hr_soft_coding_keyflex hsck
225: , per_assignments_f paf
226: , pay_assignment_actions paa
227: , pay_payroll_actions ppa
228: WHERE hsck.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
229: AND paa.assignment_action_id = p_assignment_action_id

Line 443: , per_assignments_f paf

439: CURSOR csr_get_tax_unit_id
440: IS
441: SELECT hsck.segment1
442: FROM hr_soft_coding_keyflex hsck
443: , per_assignments_f paf
444: , pay_assignment_actions paa
445: , pay_payroll_actions ppa
446: WHERE hsck.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
447: AND paa.assignment_action_id = p_assignment_action_id

Line 587: l_assignment_id per_assignments_f.assignment_id%TYPE;

583: l_uom pay_accrual_plans.accrual_units_of_measure%TYPE;
584: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
585: l_business_group_id per_business_groups.business_group_id%TYPE;
586: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%TYPE;
587: l_assignment_id per_assignments_f.assignment_id%TYPE;
588: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
589: l_annual_leave_balance NUMBER;
590: l_ovn NUMBER;
591: l_leave_taken NUMBER;