APPS.BEN_CWB_DATA_MODEL_UPGRADE dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 1510: from per_assignment_extra_info ext

1506:
1507: cursor c_rank is
1508: select ext.assignment_extra_info_id
1509: ,pen.per_in_ler_id
1510: from per_assignment_extra_info ext
1511: ,per_all_assignments_f asg
1512: ,ben_prtt_enrt_rslt_f pen
1513: where ext.information_type = 'CWBRANK'
1514: and ext.aei_information_category = 'CWBRANK'

Line 1619: update per_assignment_extra_info ext

1615: begin
1616:
1617: -- Rank Updates
1618:
1619: update per_assignment_extra_info ext
1620: set ext.aei_information1 = rtrim(ltrim(ext.aei_information1))
1621: where ext.information_type = 'CWBRANK'
1622: and ext.aei_information_category = 'CWBRANK'
1623: and ext.aei_information1 is not null;

Line 1627: update per_assignment_extra_info ext

1623: and ext.aei_information1 is not null;
1624:
1625: commit_and_log('Removing Extra Spaces from Rank Complete');
1626:
1627: update per_assignment_extra_info ext
1628: set ext.aei_information1 = null
1629: where ext.information_type = 'CWBRANK'
1630: and ext.aei_information_category = 'CWBRANK'
1631: and ext.aei_information1 is not null

Line 1648: update per_assignment_extra_info ext

1644:
1645: if l_t_info_id.count > 0 then
1646:
1647: forall i in l_t_info_id.first .. l_t_info_id.last
1648: update per_assignment_extra_info ext
1649: set ext.aei_information3 = l_t_per_in_ler_id(i)
1650: where ext.assignment_extra_info_id = l_t_info_id(i);
1651:
1652: end if;