APPS.BEN_BENBOAUD_XMLP_PKG dependencies on BEN_BENEFIT_ACTIONS

Line 74: ben_benefit_actions b

70: fnd_message.set_name('BEN','BEN_91792_ALL_PROMPT');
71: l_all := substrb(fnd_message.get,1,80);
72: select name into CP_PERSON_BNFT_GRP
73: from ben_benfts_grp a,
74: ben_benefit_actions b
75: where a.benfts_grp_id = b.benfts_grp_id
76: and b.request_id = P_CONCURRENT_REQUEST_ID;
77:
78:

Line 85: ben_benefit_actions b

81: end;
82: begin
83: select location_code into CP_LOCATION
84: from hr_locations a,
85: ben_benefit_actions b
86: where a.location_id = b.location_id
87: and b.request_id = P_CONCURRENT_REQUEST_ID;
88:
89: exception when no_data_found then

Line 94: from ben_benefit_actions

90: CP_LOCATION := l_all;
91: end;
92: begin
93: select date_from, uneai_effective_date into CP_FROM_OCRD_DT, CP_TO_OCRD_DT
94: from ben_benefit_actions
95: where request_id = P_CONCURRENT_REQUEST_ID;
96:
97: exception when no_data_found then
98: null;

Line 103: from ben_benefit_actions bft, hr_lookups hl

99: end;
100:
101: begin
102: select hl.meaning into CP_RESULTING_STATUS
103: from ben_benefit_actions bft, hr_lookups hl
104: where bft.PTNL_LER_FOR_PER_STAT_CD = hl.lookup_code
105: and hl.lookup_type = 'BEN_PTNL_LER_FOR_PER_STAT'
106: and bft.request_id = P_CONCURRENT_REQUEST_ID;
107: