DBA Data[Home] [Help]

APPS.BEN_BENAUDIT_XMLP_PKG dependencies on BEN_BENEFIT_ACTIONS

Line 82: ben_benefit_actions bft

78: l_all := substrb(fnd_message.get,1,80);
79: begin
80: select loc.location_code into CP_LOCATION
81: from hr_locations loc,
82: ben_benefit_actions bft
83: where bft.request_id = P_CONCURRENT_REQUEST_ID
84: and bft.location_id = loc.location_id;
85:
86: exception

Line 94: ben_benefit_actions bft

90:
91: begin
92: select bng.name into CP_PERSON_BNFT_GRP
93: from ben_benfts_grp bng,
94: ben_benefit_actions bft
95: where bft.request_id = P_CONCURRENT_REQUEST_ID
96: and bft.benfts_grp_id = bng.benfts_grp_id;
97:
98: exception

Line 105: from ben_benefit_actions bft

101: end;
102:
103: begin
104: select decode(audit_log_flag, 'Y', 'Yes', 'N', 'No') into CP_AUDIT_FLAG
105: from ben_benefit_actions bft
106: where bft.request_id = P_CONCURRENT_REQUEST_ID;
107:
108:
109: exception

Line 116: from ben_benefit_actions bft

112: end;
113:
114: begin
115: select decode(lmt_prpnip_by_org_flag, 'Y', 'Yes', 'N', 'No') into CP_LMT_BY_ORG_FLAG
116: from ben_benefit_actions bft
117: where bft.request_id = P_CONCURRENT_REQUEST_ID;
118:
119:
120: exception