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

Line 904: l_business_group_id_from PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE;

900: l_from varchar2(15);
901: l_cancel_boolean BOOLEAN;
902: l_auto_create_finance VARCHAR2(40);
903: l_price_basis OTA_EVENTS.price_basis%TYPE;
904: l_business_group_id_from PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE;
905: l_business_group_id_to hr_all_organization_units.organization_id%type;
906: l_assignment_id PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE;
907: l_organization_id PER_ALL_ASSIGNMENTS_F.organization_id%TYPE;
908: l_user NUMBER;

Line 906: l_assignment_id PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE;

902: l_auto_create_finance VARCHAR2(40);
903: l_price_basis OTA_EVENTS.price_basis%TYPE;
904: l_business_group_id_from PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE;
905: l_business_group_id_to hr_all_organization_units.organization_id%type;
906: l_assignment_id PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE;
907: l_organization_id PER_ALL_ASSIGNMENTS_F.organization_id%TYPE;
908: l_user NUMBER;
909: fapi_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;
910: fapi_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;

Line 907: l_organization_id PER_ALL_ASSIGNMENTS_F.organization_id%TYPE;

903: l_price_basis OTA_EVENTS.price_basis%TYPE;
904: l_business_group_id_from PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE;
905: l_business_group_id_to hr_all_organization_units.organization_id%type;
906: l_assignment_id PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE;
907: l_organization_id PER_ALL_ASSIGNMENTS_F.organization_id%TYPE;
908: l_user NUMBER;
909: fapi_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;
910: fapi_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;
911: fapi_result VARCHAR2(40);

Line 2070: PER_ALL_ASSIGNMENTS_F asg

2066:
2067: CURSOR OFA IS
2068: SELECT hr.COST_ALLOCATION_KEYFLEX_ID
2069: FROM HR_ALL_ORGANIZATION_UNITS hr ,
2070: PER_ALL_ASSIGNMENTS_F asg
2071: WHERE hr.organization_id = asg.organization_id and
2072: asg.organization_id = p_organization_id and
2073: asg.assignment_id = p_assignment_id and
2074: trunc(sysdate) between asg.effective_start_date and

Line 2204: PER_ALL_ASSIGNMENTS_F asg

2200: FETCH OFA INTO l_cost_allocation_keyflex_id ;
2201: CLOSE OFA;
2202: /* SELECT hr.COST_ALLOCATION_KEYFLEX_ID INTO l_cost_allocation_keyflex_id
2203: FROM HR_ALL_ORGANIZATION_UNITS hr ,
2204: PER_ALL_ASSIGNMENTS_F asg
2205: WHERE hr.organization_id = asg.organization_id and
2206: asg.organization_id = p_organization_id and
2207: asg.assignment_id = p_assignment_id ; */
2208: