APPS.BEN_COBJ_CACHE dependencies on BEN_PL_F

Line 26: to ben_pl_f table

22: 115.6 22-May-01 mhoyes - Upgraded comp object caches to be context
23: sensitive. Hence when the refresh routine is
24: not called then the cache will use SQL.
25: 115.7 26-Jul-01 ikasire Bug 1895874 adding nip_dflt_flag column
26: to ben_pl_f table
27: 115.10 29-Nov-05 abparekh Bug 4766118 - Added ALWS_QDRO_FLAG to G_PL_INST_ROW
28: 115.11 13-Mar-06 kmahendr bug#5082245 - added svgs_pl_flag to g_pl_inst_row
29: -----------------------------------------------------------------------------
30: */

Line 1073: FROM BEN_PL_F TAB1

1069: tab1.postelcn_edit_rl,
1070: tab1.dpnt_cvd_by_othr_apls_flag,
1071: tab1.nip_dflt_flag,
1072: tab1.svgs_pl_flag
1073: FROM BEN_PL_F TAB1
1074: WHERE TAB1.BUSINESS_GROUP_ID = c_business_group_id
1075: AND c_effective_date
1076: BETWEEN TAB1.EFFECTIVE_START_DATE AND TAB1.EFFECTIVE_END_DATE;
1077: --

Line 1167: FROM BEN_PL_F TAB1

1163: tab1.postelcn_edit_rl,
1164: tab1.dpnt_cvd_by_othr_apls_flag,
1165: tab1.nip_dflt_flag,
1166: tab1.SVGS_PL_FLAG
1167: FROM BEN_PL_F TAB1
1168: WHERE TAB1.pl_id = c_pl_id
1169: AND c_effective_date
1170: BETWEEN TAB1.EFFECTIVE_START_DATE AND TAB1.EFFECTIVE_END_DATE;
1171: --