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

Line 1354: l_business_group_id_from PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE;

1350: l_from varchar2(15);
1351: l_cancel_boolean BOOLEAN;
1352: l_auto_create_finance VARCHAR2(40);
1353: l_price_basis OTA_EVENTS.price_basis%TYPE;
1354: l_business_group_id_from PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE;
1355: l_business_group_id_to hr_all_organization_units.organization_id%type;
1356: l_assignment_id PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE;
1357: l_organization_id PER_ALL_ASSIGNMENTS_F.organization_id%TYPE;
1358: l_user NUMBER;

Line 1356: l_assignment_id PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE;

1352: l_auto_create_finance VARCHAR2(40);
1353: l_price_basis OTA_EVENTS.price_basis%TYPE;
1354: l_business_group_id_from PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE;
1355: l_business_group_id_to hr_all_organization_units.organization_id%type;
1356: l_assignment_id PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE;
1357: l_organization_id PER_ALL_ASSIGNMENTS_F.organization_id%TYPE;
1358: l_user NUMBER;
1359: fapi_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;
1360: fapi_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;

Line 1357: l_organization_id PER_ALL_ASSIGNMENTS_F.organization_id%TYPE;

1353: l_price_basis OTA_EVENTS.price_basis%TYPE;
1354: l_business_group_id_from PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE;
1355: l_business_group_id_to hr_all_organization_units.organization_id%type;
1356: l_assignment_id PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE;
1357: l_organization_id PER_ALL_ASSIGNMENTS_F.organization_id%TYPE;
1358: l_user NUMBER;
1359: fapi_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;
1360: fapi_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;
1361: fapi_result VARCHAR2(40);

Line 2549: PER_ALL_ASSIGNMENTS_F asg

2545:
2546: CURSOR OFA IS
2547: SELECT hr.COST_ALLOCATION_KEYFLEX_ID
2548: FROM HR_ALL_ORGANIZATION_UNITS hr ,
2549: PER_ALL_ASSIGNMENTS_F asg
2550: WHERE hr.organization_id = asg.organization_id and
2551: asg.organization_id = p_organization_id and
2552: asg.assignment_id = p_assignment_id and
2553: trunc(sysdate) between asg.effective_start_date and

Line 2683: PER_ALL_ASSIGNMENTS_F asg

2679: FETCH OFA INTO l_cost_allocation_keyflex_id ;
2680: CLOSE OFA;
2681: /* SELECT hr.COST_ALLOCATION_KEYFLEX_ID INTO l_cost_allocation_keyflex_id
2682: FROM HR_ALL_ORGANIZATION_UNITS hr ,
2683: PER_ALL_ASSIGNMENTS_F asg
2684: WHERE hr.organization_id = asg.organization_id and
2685: asg.organization_id = p_organization_id and
2686: asg.assignment_id = p_assignment_id ; */
2687:

Line 2921: PER_ALL_ASSIGNMENTS_F asg

2917: FETCH OFA INTO l_cost_allocation_keyflex_id ;
2918: CLOSE OFA;
2919: /* SELECT hr.COST_ALLOCATION_KEYFLEX_ID INTO l_cost_allocation_keyflex_id
2920: FROM HR_ALL_ORGANIZATION_UNITS hr ,
2921: PER_ALL_ASSIGNMENTS_F asg
2922: WHERE hr.organization_id = asg.organization_id and
2923: asg.organization_id = p_organization_id and
2924: asg.assignment_id = p_assignment_id ; */
2925: