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.HXT_TIMECARD_API dependencies on PER_ASSIGNMENTS_F

Line 20: FROM per_assignments_f asg

16: SELECT asg.payroll_id,
17: asg.assignment_number,
18: asg.assignment_id,
19: asg.business_group_id
20: FROM per_assignments_f asg
21: --HXT11i1 per_people_f per
22: WHERE asg.person_id = i_employee_id --HXT11i1
23: --HXT11i1 per.employee_number = i_employee_number
24: --HXT11i1 AND per.person_id = asg.person_id

Line 44: l_payroll_id per_assignments_f.payroll_id%TYPE := NULL;

40:
41: l_accrual_category pay_accrual_plans.accrual_category%TYPE := NULL;
42: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%TYPE := NULL;
43: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%TYPE := NULL;
44: l_payroll_id per_assignments_f.payroll_id%TYPE := NULL;
45: l_assignment_number per_assignments_f.assignment_number%TYPE := NULL;
46: l_assignment_id per_assignments_f.assignment_id%TYPE := NULL;
47: l_business_group_id per_assignments_f.business_group_id%TYPE := NULL;
48: l_net_accrual_amt NUMBER (7,3);

Line 45: l_assignment_number per_assignments_f.assignment_number%TYPE := NULL;

41: l_accrual_category pay_accrual_plans.accrual_category%TYPE := NULL;
42: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%TYPE := NULL;
43: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%TYPE := NULL;
44: l_payroll_id per_assignments_f.payroll_id%TYPE := NULL;
45: l_assignment_number per_assignments_f.assignment_number%TYPE := NULL;
46: l_assignment_id per_assignments_f.assignment_id%TYPE := NULL;
47: l_business_group_id per_assignments_f.business_group_id%TYPE := NULL;
48: l_net_accrual_amt NUMBER (7,3);
49: l_calculation_date DATE := i_calculation_date;

Line 46: l_assignment_id per_assignments_f.assignment_id%TYPE := NULL;

42: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%TYPE := NULL;
43: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%TYPE := NULL;
44: l_payroll_id per_assignments_f.payroll_id%TYPE := NULL;
45: l_assignment_number per_assignments_f.assignment_number%TYPE := NULL;
46: l_assignment_id per_assignments_f.assignment_id%TYPE := NULL;
47: l_business_group_id per_assignments_f.business_group_id%TYPE := NULL;
48: l_net_accrual_amt NUMBER (7,3);
49: l_calculation_date DATE := i_calculation_date;
50: l_display_error VARCHAR2(120);

Line 47: l_business_group_id per_assignments_f.business_group_id%TYPE := NULL;

43: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%TYPE := NULL;
44: l_payroll_id per_assignments_f.payroll_id%TYPE := NULL;
45: l_assignment_number per_assignments_f.assignment_number%TYPE := NULL;
46: l_assignment_id per_assignments_f.assignment_id%TYPE := NULL;
47: l_business_group_id per_assignments_f.business_group_id%TYPE := NULL;
48: l_net_accrual_amt NUMBER (7,3);
49: l_calculation_date DATE := i_calculation_date;
50: l_display_error VARCHAR2(120);
51: l_oracle_error VARCHAR2(512);

Line 299: ,per_assignments_f asm

295: ,PAY_ACCRUAL_PLANS pap
296: ,PAY_NET_CALCULATION_RULES net
297: ,PAY_INPUT_VALUES_F piv
298: ,hxt_sum_hours_worked sm
299: ,per_assignments_f asm
300: WHERE elt.element_type_id = eltv.element_type_id
301: AND eltv.hxt_earning_category = 'ABS'
302: AND sm.date_worked BETWEEN ELT.EFFECTIVE_START_DATE
303: AND ELT.EFFECTIVE_END_DATE

Line 342: ,per_assignments_f asm

338: ,PAY_ACCRUAL_PLANS pap
339: ,PAY_NET_CALCULATION_RULES net
340: ,PAY_INPUT_VALUES_F piv
341: ,hxt_sum_hours_worked sm
342: ,per_assignments_f asm
343: ,per_people_f ppl -- ER180 Bug Fix
344: WHERE elt.element_type_id = eltv.element_type_id
345: AND eltv.hxt_earning_category = 'ABS'
346: AND sm.date_worked = p_date_worked

Line 392: ,per_assignments_f asm

388: ,PAY_ACCRUAL_PLANS pap
389: ,PAY_NET_CALCULATION_RULES net
390: ,PAY_INPUT_VALUES_F piv
391: ,hxt_sum_hours_worked sm
392: ,per_assignments_f asm
393: WHERE elt.element_type_id = eltv.element_type_id
394: AND eltv.hxt_earning_category = 'ABS'
395: AND net.ACCRUAL_PLAN_ID = pap.ACCRUAL_PLAN_ID
396: AND pap.accrual_plan_name = p_accrual_plan_name

Line 436: ,per_assignments_f asm

432: ,PAY_ACCRUAL_PLANS pap
433: ,PAY_NET_CALCULATION_RULES net
434: ,PAY_INPUT_VALUES_F piv
435: ,hxt_det_hours_worked_f det
436: ,per_assignments_f asm
437: WHERE elt.element_type_id = eltv.element_type_id
438: AND eltv.hxt_earning_category = 'ABS'
439: AND net.ACCRUAL_PLAN_ID = pap.ACCRUAL_PLAN_ID
440: AND pap.accrual_plan_name = p_accrual_plan_name

Line 461: ,per_assignments_f asm

457: ,PAY_ACCRUAL_PLANS pap
458: ,PAY_NET_CALCULATION_RULES net
459: ,PAY_INPUT_VALUES_F piv
460: ,hxt_det_hours_worked_f det
461: ,per_assignments_f asm
462: WHERE elt.element_type_id = eltv.element_type_id
463: AND eltv.hxt_earning_category = 'ABS'
464: AND net.ACCRUAL_PLAN_ID = pap.ACCRUAL_PLAN_ID
465: AND pap.accrual_plan_name = p_accrual_plan_name