APPS.OTA_LEARNER_ENROLL_REVIEW_SS dependencies on PER_ALL_ASSIGNMENTS_F

Line 982: l_business_group_id_from PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE;

978: l_from varchar2(15);
979: l_cancel_boolean BOOLEAN;
980: l_auto_create_finance VARCHAR2(40);
981: l_price_basis OTA_EVENTS.price_basis%TYPE;
982: l_business_group_id_from PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE;
983: l_business_group_id_to hr_all_organization_units.organization_id%type;
984: l_assignment_id PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE;
985: l_organization_id PER_ALL_ASSIGNMENTS_F.organization_id%TYPE;
986: l_user NUMBER;

Line 984: l_assignment_id PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE;

980: l_auto_create_finance VARCHAR2(40);
981: l_price_basis OTA_EVENTS.price_basis%TYPE;
982: l_business_group_id_from PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE;
983: l_business_group_id_to hr_all_organization_units.organization_id%type;
984: l_assignment_id PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE;
985: l_organization_id PER_ALL_ASSIGNMENTS_F.organization_id%TYPE;
986: l_user NUMBER;
987: fapi_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;
988: fapi_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;

Line 985: l_organization_id PER_ALL_ASSIGNMENTS_F.organization_id%TYPE;

981: l_price_basis OTA_EVENTS.price_basis%TYPE;
982: l_business_group_id_from PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE;
983: l_business_group_id_to hr_all_organization_units.organization_id%type;
984: l_assignment_id PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE;
985: l_organization_id PER_ALL_ASSIGNMENTS_F.organization_id%TYPE;
986: l_user NUMBER;
987: fapi_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;
988: fapi_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;
989: fapi_result VARCHAR2(40);

Line 2160: PER_ALL_ASSIGNMENTS_F asg

2156:
2157: CURSOR OFA IS
2158: SELECT hr.COST_ALLOCATION_KEYFLEX_ID
2159: FROM HR_ALL_ORGANIZATION_UNITS hr ,
2160: PER_ALL_ASSIGNMENTS_F asg
2161: WHERE hr.organization_id = asg.organization_id and
2162: asg.organization_id = p_organization_id and
2163: asg.assignment_id = p_assignment_id and
2164: trunc(sysdate) between asg.effective_start_date and

Line 2294: PER_ALL_ASSIGNMENTS_F asg

2290: FETCH OFA INTO l_cost_allocation_keyflex_id ;
2291: CLOSE OFA;
2292: /* SELECT hr.COST_ALLOCATION_KEYFLEX_ID INTO l_cost_allocation_keyflex_id
2293: FROM HR_ALL_ORGANIZATION_UNITS hr ,
2294: PER_ALL_ASSIGNMENTS_F asg
2295: WHERE hr.organization_id = asg.organization_id and
2296: asg.organization_id = p_organization_id and
2297: asg.assignment_id = p_assignment_id ; */
2298: