DBA Data[Home] [Help]

APPS.BEN_PER_CM_API dependencies on BEN_PER_CM_TRGR_F

Line 1116: from ben_per_cm_trgr_f

1112: select per_cm_trgr_id,
1113: object_version_number,
1114: effective_start_date,
1115: effective_end_date
1116: from ben_per_cm_trgr_f
1117: where per_cm_id = p_per_cm_id
1118: and p_effective_date
1119: between effective_start_date
1120: and effective_end_date;

Line 1192: and then open the results of child tables ben_per_cm_trgr_f,ben_per_cm_usg_f,ben_per_cm_prvdd_f*/

1188: end;
1189:
1190: /* Bug 9964529: While backing out the LE, while deleting the communication
1191: records in future change mode, first open the results of parent table ie ben_per_cm_f
1192: and then open the results of child tables ben_per_cm_trgr_f,ben_per_cm_usg_f,ben_per_cm_prvdd_f*/
1193: if(ben_back_out_life_event.g_backout_flag = 'Y') then
1194: ben_pcm_del.del
1195: (p_per_cm_id => p_per_cm_id
1196: ,p_effective_start_date => l_effective_start_date

Line 1254: child tables ie ben_per_cm_trgr_f,ben_per_cm_usg_f,ben_per_cm_prvdd_f and then

1250: --
1251: -- Call the pcm rowhandler to delete the row.
1252: --
1253: /* Bug 9964529: While deleting the communication records when a LE is processed, first end the results of
1254: child tables ie ben_per_cm_trgr_f,ben_per_cm_usg_f,ben_per_cm_prvdd_f and then
1255: end the result of parent table ben_per_cm_f*/
1256: if( nvl(ben_back_out_life_event.g_backout_flag,'N') = 'N') then
1257: ben_pcm_del.del
1258: (p_per_cm_id => p_per_cm_id