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.

[Home] [Help]

APPS.PAY_CN_SOE dependencies on PER_ASSIGNMENTS_F

Line 198: , per_assignments_f paf

194: CURSOR csr_get_tax_unit_id
195: IS
196: SELECT hsck.segment1
197: FROM hr_soft_coding_keyflex hsck
198: , per_assignments_f paf
199: , pay_assignment_actions paa
200: , pay_payroll_actions ppa
201: WHERE hsck.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
202: AND paa.assignment_action_id = p_assignment_action_id

Line 414: , per_assignments_f paf

410: CURSOR csr_get_tax_unit_id
411: IS
412: SELECT hsck.segment1
413: FROM hr_soft_coding_keyflex hsck
414: , per_assignments_f paf
415: , pay_assignment_actions paa
416: , pay_payroll_actions ppa
417: WHERE hsck.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
418: AND paa.assignment_action_id = p_assignment_action_id

Line 525: l_assignment_id per_assignments_f.assignment_id%TYPE;

521: l_uom pay_accrual_plans.accrual_units_of_measure%TYPE;
522: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
523: l_business_group_id per_business_groups.business_group_id%TYPE;
524: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%TYPE;
525: l_assignment_id per_assignments_f.assignment_id%TYPE;
526: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
527: l_annual_leave_balance NUMBER;
528: l_ovn NUMBER;
529: l_leave_taken NUMBER;