DBA Data[Home] [Help]

APPS.GHR_US_NFC_EXTRACTS dependencies on BEN_BENEFIT_ACTIONS

Line 77: FROM ben_benefit_actions bba

73: CURSOR csr_org_req (c_ext_dfn_id IN NUMBER
74: ,c_ext_rslt_id IN NUMBER
75: ,c_business_group_id IN NUMBER) IS
76: SELECT bba.request_id
77: FROM ben_benefit_actions bba
78: WHERE bba.pl_id = c_ext_rslt_id
79: AND bba.pgm_id = c_ext_dfn_id
80: AND bba.business_group_id = c_business_group_id;
81:

Line 204: FROM ben_benefit_actions ben

200: ,ben.benefit_action_id
201: ,ben.business_group_id
202: ,ben.process_date
203: ,ben.request_id
204: FROM ben_benefit_actions ben
205: WHERE ben.pl_id = c_ext_rslt_id
206: AND ben.pgm_id = c_ext_dfn_id
207: AND ben.business_group_id = c_business_group_id;
208:

Line 6698: FROM ben_benefit_actions bba

6694:
6695: CURSOR csr_jcl_org_req (c_ext_dfn_id IN NUMBER
6696: ,c_ext_rslt_id IN NUMBER ) IS
6697: SELECT bba.request_id
6698: FROM ben_benefit_actions bba
6699: WHERE bba.pl_id = c_ext_rslt_id
6700: AND bba.pgm_id = c_ext_dfn_id ;
6701:
6702: