APPS.BEN_OPT_BUS dependencies on BEN_PL_TYP_OPT_TYP_F

Line 91: ben_pl_typ_opt_typ_f pto

87:
88: cursor c_opt_cwb is
89: select opt_typ_cd
90: from ben_pl_typ_f plt,
91: ben_pl_typ_opt_typ_f pto
92: where pto.opt_id = p_opt_id
93: and plt.pl_typ_id = pto.pl_typ_id
94: and p_effective_date between plt.effective_start_date
95: and plt.effective_end_Date

Line 161: from ben_pl_typ_opt_typ_f pto ,

157:
158:
159: cursor c_opt_cwb is
160: select opt_typ_cd
161: from ben_pl_typ_opt_typ_f pto ,
162: ben_pl_typ_f plt
163: where pto.opt_id = p_opt_id
164: and plt.pl_typ_id = pto.pl_typ_id
165: and plt.opt_typ_cd = 'CWB'

Line 1062: (p_base_table_name => 'ben_pl_typ_opt_typ_f',

1058: l_table_name := 'ben_dsgn_rqmt_f';
1059: Raise l_rows_exist;
1060: End If;
1061: If (dt_api.rows_exist
1062: (p_base_table_name => 'ben_pl_typ_opt_typ_f',
1063: p_base_key_column => 'opt_id',
1064: p_base_key_value => p_opt_id,
1065: p_from_date => p_validation_start_date,
1066: p_to_date => p_validation_end_date)) Then

Line 1067: l_table_name := 'ben_pl_typ_opt_typ_f';

1063: p_base_key_column => 'opt_id',
1064: p_base_key_value => p_opt_id,
1065: p_from_date => p_validation_start_date,
1066: p_to_date => p_validation_end_date)) Then
1067: l_table_name := 'ben_pl_typ_opt_typ_f';
1068: Raise l_rows_exist;
1069: End If;
1070: --
1071: End If;