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_EL_TRAINING_SS dependencies on PER_ALL_ASSIGNMENTS_F

Line 1099: l_business_group_id_from PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE;

1095: l_from varchar2(15);
1096: l_cancel_boolean BOOLEAN;
1097: l_auto_create_finance VARCHAR2(40);
1098: l_price_basis OTA_EVENTS.price_basis%TYPE;
1099: l_business_group_id_from PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE;
1100: l_business_group_id_to hr_all_organization_units.organization_id%type;
1101: l_assignment_id PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE;
1102: l_organization_id PER_ALL_ASSIGNMENTS_F.organization_id%TYPE;
1103: l_user NUMBER;

Line 1101: l_assignment_id PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE;

1097: l_auto_create_finance VARCHAR2(40);
1098: l_price_basis OTA_EVENTS.price_basis%TYPE;
1099: l_business_group_id_from PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE;
1100: l_business_group_id_to hr_all_organization_units.organization_id%type;
1101: l_assignment_id PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE;
1102: l_organization_id PER_ALL_ASSIGNMENTS_F.organization_id%TYPE;
1103: l_user NUMBER;
1104: fapi_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;
1105: fapi_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;

Line 1102: l_organization_id PER_ALL_ASSIGNMENTS_F.organization_id%TYPE;

1098: l_price_basis OTA_EVENTS.price_basis%TYPE;
1099: l_business_group_id_from PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE;
1100: l_business_group_id_to hr_all_organization_units.organization_id%type;
1101: l_assignment_id PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE;
1102: l_organization_id PER_ALL_ASSIGNMENTS_F.organization_id%TYPE;
1103: l_user NUMBER;
1104: fapi_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;
1105: fapi_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;
1106: fapi_result VARCHAR2(40);

Line 2139: PER_ALL_ASSIGNMENTS_F asg

2135:
2136: CURSOR OFA IS
2137: SELECT hr.COST_ALLOCATION_KEYFLEX_ID
2138: FROM HR_ALL_ORGANIZATION_UNITS hr ,
2139: PER_ALL_ASSIGNMENTS_F asg
2140: WHERE hr.organization_id = asg.organization_id and
2141: asg.organization_id = p_organization_id and
2142: asg.assignment_id = p_assignment_id and
2143: trunc(sysdate) between asg.effective_start_date and

Line 2273: PER_ALL_ASSIGNMENTS_F asg

2269: FETCH OFA INTO l_cost_allocation_keyflex_id ;
2270: CLOSE OFA;
2271: /* SELECT hr.COST_ALLOCATION_KEYFLEX_ID INTO l_cost_allocation_keyflex_id
2272: FROM HR_ALL_ORGANIZATION_UNITS hr ,
2273: PER_ALL_ASSIGNMENTS_F asg
2274: WHERE hr.organization_id = asg.organization_id and
2275: asg.organization_id = p_organization_id and
2276: asg.assignment_id = p_assignment_id ; */
2277:

Line 2511: PER_ALL_ASSIGNMENTS_F asg

2507: FETCH OFA INTO l_cost_allocation_keyflex_id ;
2508: CLOSE OFA;
2509: /* SELECT hr.COST_ALLOCATION_KEYFLEX_ID INTO l_cost_allocation_keyflex_id
2510: FROM HR_ALL_ORGANIZATION_UNITS hr ,
2511: PER_ALL_ASSIGNMENTS_F asg
2512: WHERE hr.organization_id = asg.organization_id and
2513: asg.organization_id = p_organization_id and
2514: asg.assignment_id = p_assignment_id ; */
2515: