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

Line 1246: FROM per_all_assignments_f

1242: p_evaluation_date IN date,
1243: p_dividing_factor IN number)
1244: IS
1245: SELECT normal_hours/p_dividing_factor
1246: FROM per_all_assignments_f
1247: WHERE person_id =p_reource_id
1248: AND assignment_type in ('E','C')
1249: AND primary_flag = 'Y'
1250: AND TRUNC(p_evaluation_date) BETWEEN effective_start_date AND effective_end_Date;

Line 1606: FROM per_all_assignments_f

1602:
1603: cursor c_check_bussiness_group_id(p_person_id number, p_timecard_start_date date) is
1604: SELECT business_group_id,
1605: organization_id
1606: FROM per_all_assignments_f
1607: WHERE person_id = p_person_id
1608: AND assignment_type IN('E', 'C')
1609: AND primary_flag = 'Y'
1610: AND p_timecard_start_date BETWEEN effective_start_date AND effective_end_date;

Line 1612: l_business_group_id per_all_assignments_f.business_group_id%type;

1608: AND assignment_type IN('E', 'C')
1609: AND primary_flag = 'Y'
1610: AND p_timecard_start_date BETWEEN effective_start_date AND effective_end_date;
1611:
1612: l_business_group_id per_all_assignments_f.business_group_id%type;
1613: l_organization_id per_all_assignments_f.organization_id%type;
1614:
1615:
1616: Begin

Line 1613: l_organization_id per_all_assignments_f.organization_id%type;

1609: AND primary_flag = 'Y'
1610: AND p_timecard_start_date BETWEEN effective_start_date AND effective_end_date;
1611:
1612: l_business_group_id per_all_assignments_f.business_group_id%type;
1613: l_organization_id per_all_assignments_f.organization_id%type;
1614:
1615:
1616: Begin
1617: