APPS.OTA_TRAINING_PLAN_UPGRADE dependencies on OTA_TRAINING_PLAN_MEMBERS

Line 1289: FROM ota_training_plan_members tpm

1285: ,tpm.ATTRIBUTE24 ,tpm.ATTRIBUTE25
1286: ,tpm.ATTRIBUTE26 ,tpm.ATTRIBUTE27
1287: ,tpm.ATTRIBUTE28 ,tpm.ATTRIBUTE29
1288: ,tpm.ATTRIBUTE30
1289: FROM ota_training_plan_members tpm
1290: WHERE tpm.training_plan_id = p_training_plan_id;
1291: --
1292:
1293: BEGIN

Line 1538: FROM ota_training_plans tps,Ota_training_plan_members tpm

1534:
1535:
1536: cursor csr_get_talent_mgmt_comb is
1537: SELECT distinct Tpm.source_id,Tpm.source_function, Tpm.assignment_id, tps.person_id
1538: FROM ota_training_plans tps,Ota_training_plan_members tpm
1539: WHERE PLAN_SOURCE = 'TALENT_MGMT'
1540: AND tpm.training_plan_id = tps.training_plan_id
1541: AND tps.PERSON_ID is not NULL;
1542:

Line 1628: FROM ota_training_plans tps, Ota_training_plan_members tpm

1624: ,tps.ATTRIBUTE27 tps_attribute27
1625: ,tps.ATTRIBUTE28 tps_attribute28
1626: ,tps.ATTRIBUTE29 tps_attribute29
1627: ,tps.ATTRIBUTE30 tps_ATTRIBUTE30
1628: FROM ota_training_plans tps, Ota_training_plan_members tpm
1629: WHERE tps.PLAN_SOURCE = 'TALENT_MGMT'
1630: AND tps.PERSON_ID = p_person_id
1631: --AND PERSON_ID is not NULL
1632: AND tpm.training_plan_id = tps.training_plan_id

Line 1642: FROM Ota_training_plan_members tpm, ota_training_plans tps

1638: cursor csr_member_status (p_source_id in number
1639: ,p_source_function in varchar2, p_assignment_id in number, p_person_id IN NUMBER) is
1640: SELECT decode(member_status_type_id, 'OTA_PLANNED', 0,'ACTIVE', 0, 'OTA_AWAITING_APPROVAL',0, 'OTA_COMPLETED',1,
1641: 'CANCELLED',2) top_status
1642: FROM Ota_training_plan_members tpm, ota_training_plans tps
1643: WHERE tps.training_plan_id = tpm.training_plan_id
1644: AND tpm.source_function = p_source_function
1645: AND (tpm.source_id is null or tpm.source_id = p_source_id)
1646: AND (tpm.assignment_id is null or tpm.assignment_id = p_assignment_id)

Line 1992: FROM ota_training_plan_members tpm,

1988: ,tpm.ATTRIBUTE24 ,tpm.ATTRIBUTE25
1989: ,tpm.ATTRIBUTE26 ,tpm.ATTRIBUTE27
1990: ,tpm.ATTRIBUTE28 ,tpm.ATTRIBUTE29
1991: ,tpm.ATTRIBUTE30
1992: FROM ota_training_plan_members tpm,
1993: ota_training_plans tp,
1994: ota_learning_path_members lpm,
1995: ota_learning_paths lps
1996: WHERE tp.training_plan_id = p_training_plan_id

Line 2294: FROM ota_training_plan_members tpm, ota_training_plans tps

2290: AND ROWNUM=1;
2291:
2292: Cursor csr_get_attrib_personal_tpm is
2293: SELECT 1
2294: FROM ota_training_plan_members tpm, ota_training_plans tps
2295: WHERE (tps.PERSON_ID is not NULL OR contact_id is not null)
2296: AND (TPM.ATTRIBUTE_CATEGORY||TPM.ATTRIBUTE1||TPM.ATTRIBUTE2||TPM.ATTRIBUTE3||TPM.ATTRIBUTE4||
2297: TPM.ATTRIBUTE5||TPM.ATTRIBUTE6||TPM.ATTRIBUTE7 ||TPM.ATTRIBUTE9||TPM.ATTRIBUTE10||TPM.ATTRIBUTE11||
2298: TPM.ATTRIBUTE12||TPM.ATTRIBUTE13||TPM.ATTRIBUTE14||TPM.ATTRIBUTE15||TPM.ATTRIBUTE16 ||

Line 2446: migrate_dff_contexts('OTA_TRAINING_PLAN_MEMBERS','OTA_LP_MEMBER_ENROLLMENTS','ATTRIBUTE','ATTRIBUTE',p_update_id);

2442: /* Create DFF context for LPME from personal TPM */
2443: Open csr_get_attrib_personal_tpm;
2444: Fetch csr_get_attrib_personal_tpm into l_flex_val;
2445: if l_flex_val is not null then
2446: migrate_dff_contexts('OTA_TRAINING_PLAN_MEMBERS','OTA_LP_MEMBER_ENROLLMENTS','ATTRIBUTE','ATTRIBUTE',p_update_id);
2447: end if;
2448: Close csr_get_attrib_personal_tpm;
2449: SELECT nvl(count(1),0)
2450: INTO l_rows_processed