DBA Data[Home] [Help]

APPS.BEN_EXT_PERSON dependencies on BEN_PER_IN_LER

Line 279: g_per_in_ler_id ben_per_in_ler.per_in_ler_id%TYPE;

275: g_payroll_costing_id pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
276: g_payroll_consolidation_set pay_consolidation_sets.consolidation_set_name%TYPE;
277: g_payroll_consolidation_set_id pay_consolidation_sets.consolidation_set_id%TYPE;
278: --
279: g_per_in_ler_id ben_per_in_ler.per_in_ler_id%TYPE;
280: g_ler_name ben_ler_f.name%TYPE;
281: g_ler_id ben_ler_f.ler_id%TYPE;
282: g_lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%TYPE;
283: g_lf_evt_note_dt ben_per_in_ler.ntfn_dt%TYPE;

Line 282: g_lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%TYPE;

278: --
279: g_per_in_ler_id ben_per_in_ler.per_in_ler_id%TYPE;
280: g_ler_name ben_ler_f.name%TYPE;
281: g_ler_id ben_ler_f.ler_id%TYPE;
282: g_lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%TYPE;
283: g_lf_evt_note_dt ben_per_in_ler.ntfn_dt%TYPE;
284: --
285: g_assignment_id per_all_assignments_f.assignment_id%TYPE;
286: g_employee_category per_all_assignments_f.employment_category%TYPE;

Line 283: g_lf_evt_note_dt ben_per_in_ler.ntfn_dt%TYPE;

279: g_per_in_ler_id ben_per_in_ler.per_in_ler_id%TYPE;
280: g_ler_name ben_ler_f.name%TYPE;
281: g_ler_id ben_ler_f.ler_id%TYPE;
282: g_lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%TYPE;
283: g_lf_evt_note_dt ben_per_in_ler.ntfn_dt%TYPE;
284: --
285: g_assignment_id per_all_assignments_f.assignment_id%TYPE;
286: g_employee_category per_all_assignments_f.employment_category%TYPE;
287: g_employee_barg_unit per_all_assignments_f.bargaining_unit_code%TYPE;

Line 485: g_enrt_lfevt_status ben_per_in_ler.per_in_ler_stat_cd%TYPE;

481: g_opt_attr_8 ben_opt_f.opt_attribute8%TYPE;
482: g_opt_attr_9 ben_opt_f.opt_attribute9%TYPE;
483: g_opt_attr_10 ben_opt_f.opt_attribute10%TYPE;
484: g_enrt_lfevt_name ben_ler_f.name%TYPE;
485: g_enrt_lfevt_status ben_per_in_ler.per_in_ler_stat_cd%TYPE;
486: g_enrt_lfevt_note_dt ben_per_in_ler.ntfn_dt%TYPE;
487: g_enrt_lfevt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%TYPE;
488: g_prem_actl_prem_id ben_actl_prem_f.actl_prem_id%type;
489: g_prem_mn_amt ben_prtt_prem_by_mo_f.val%TYPE;

Line 486: g_enrt_lfevt_note_dt ben_per_in_ler.ntfn_dt%TYPE;

482: g_opt_attr_9 ben_opt_f.opt_attribute9%TYPE;
483: g_opt_attr_10 ben_opt_f.opt_attribute10%TYPE;
484: g_enrt_lfevt_name ben_ler_f.name%TYPE;
485: g_enrt_lfevt_status ben_per_in_ler.per_in_ler_stat_cd%TYPE;
486: g_enrt_lfevt_note_dt ben_per_in_ler.ntfn_dt%TYPE;
487: g_enrt_lfevt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%TYPE;
488: g_prem_actl_prem_id ben_actl_prem_f.actl_prem_id%type;
489: g_prem_mn_amt ben_prtt_prem_by_mo_f.val%TYPE;
490: g_prem_mn_uom ben_prtt_prem_by_mo_f.uom%TYPE;

Line 487: g_enrt_lfevt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%TYPE;

483: g_opt_attr_10 ben_opt_f.opt_attribute10%TYPE;
484: g_enrt_lfevt_name ben_ler_f.name%TYPE;
485: g_enrt_lfevt_status ben_per_in_ler.per_in_ler_stat_cd%TYPE;
486: g_enrt_lfevt_note_dt ben_per_in_ler.ntfn_dt%TYPE;
487: g_enrt_lfevt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%TYPE;
488: g_prem_actl_prem_id ben_actl_prem_f.actl_prem_id%type;
489: g_prem_mn_amt ben_prtt_prem_by_mo_f.val%TYPE;
490: g_prem_mn_uom ben_prtt_prem_by_mo_f.uom%TYPE;
491: g_prem_mn_cramt ben_prtt_prem_by_mo_f.cr_val%TYPE;

Line 719: g_cm_lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%TYPE;

715: g_cm_type ben_cm_typ_f.name%type;
716: g_cm_type_id ben_cm_typ_f.cm_typ_id%type;
717: g_cm_short_name ben_cm_typ_f.shrt_name%type;
718: g_cm_kit ben_cm_typ_f.pc_kit_cd%type;
719: g_cm_lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%TYPE;
720: g_cm_lf_evt ben_ler_f.name%TYPE;
721: g_cm_lf_evt_id ben_ler_f.ler_id%TYPE;
722: g_cm_lf_evt_stat ben_per_in_ler.per_in_ler_stat_cd%TYPE;
723: g_cm_lf_evt_ntfn_dt ben_per_in_ler.ntfn_dt%TYPE;

Line 722: g_cm_lf_evt_stat ben_per_in_ler.per_in_ler_stat_cd%TYPE;

718: g_cm_kit ben_cm_typ_f.pc_kit_cd%type;
719: g_cm_lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%TYPE;
720: g_cm_lf_evt ben_ler_f.name%TYPE;
721: g_cm_lf_evt_id ben_ler_f.ler_id%TYPE;
722: g_cm_lf_evt_stat ben_per_in_ler.per_in_ler_stat_cd%TYPE;
723: g_cm_lf_evt_ntfn_dt ben_per_in_ler.ntfn_dt%TYPE;
724: g_cm_per_in_ler_id ben_per_cm_f.per_in_ler_id%TYPE;
725: g_cm_prtt_enrt_actn_id ben_per_cm_f.prtt_enrt_actn_id%TYPE;
726: g_cm_trgr_proc_name ben_cm_trgr.proc_cd%type;

Line 723: g_cm_lf_evt_ntfn_dt ben_per_in_ler.ntfn_dt%TYPE;

719: g_cm_lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%TYPE;
720: g_cm_lf_evt ben_ler_f.name%TYPE;
721: g_cm_lf_evt_id ben_ler_f.ler_id%TYPE;
722: g_cm_lf_evt_stat ben_per_in_ler.per_in_ler_stat_cd%TYPE;
723: g_cm_lf_evt_ntfn_dt ben_per_in_ler.ntfn_dt%TYPE;
724: g_cm_per_in_ler_id ben_per_cm_f.per_in_ler_id%TYPE;
725: g_cm_prtt_enrt_actn_id ben_per_cm_f.prtt_enrt_actn_id%TYPE;
726: g_cm_trgr_proc_name ben_cm_trgr.proc_cd%type;
727: g_cm_trgr_proc_dt ben_per_cm_trgr_f.effective_start_date%type;

Line 919: g_elig_lfevt_status ben_per_in_ler.per_in_ler_stat_cd%TYPE;

915: g_elig_opt_flex_09 ben_opt_f.opt_attribute9%TYPE;
916: g_elig_opt_flex_10 ben_opt_f.opt_attribute10%TYPE;
917: g_elig_lfevt_name ben_ler_f.name%TYPE;
918: g_elig_ler_id ben_ler_f.ler_id%TYPE;
919: g_elig_lfevt_status ben_per_in_ler.per_in_ler_stat_cd%TYPE;
920: g_elig_lfevt_note_dt ben_per_in_ler.ntfn_dt%TYPE;
921: g_elig_lfevt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%TYPE;
922: g_elig_pl_fd_name ben_pl_f.short_name%Type ;
923: g_elig_pl_fd_code ben_pl_f.short_code%Type ;

Line 920: g_elig_lfevt_note_dt ben_per_in_ler.ntfn_dt%TYPE;

916: g_elig_opt_flex_10 ben_opt_f.opt_attribute10%TYPE;
917: g_elig_lfevt_name ben_ler_f.name%TYPE;
918: g_elig_ler_id ben_ler_f.ler_id%TYPE;
919: g_elig_lfevt_status ben_per_in_ler.per_in_ler_stat_cd%TYPE;
920: g_elig_lfevt_note_dt ben_per_in_ler.ntfn_dt%TYPE;
921: g_elig_lfevt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%TYPE;
922: g_elig_pl_fd_name ben_pl_f.short_name%Type ;
923: g_elig_pl_fd_code ben_pl_f.short_code%Type ;
924: g_elig_pgm_fd_name ben_pgm_f.short_name%Type ;

Line 921: g_elig_lfevt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%TYPE;

917: g_elig_lfevt_name ben_ler_f.name%TYPE;
918: g_elig_ler_id ben_ler_f.ler_id%TYPE;
919: g_elig_lfevt_status ben_per_in_ler.per_in_ler_stat_cd%TYPE;
920: g_elig_lfevt_note_dt ben_per_in_ler.ntfn_dt%TYPE;
921: g_elig_lfevt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%TYPE;
922: g_elig_pl_fd_name ben_pl_f.short_name%Type ;
923: g_elig_pl_fd_code ben_pl_f.short_code%Type ;
924: g_elig_pgm_fd_name ben_pgm_f.short_name%Type ;
925: g_elig_pgm_fd_code ben_pgm_f.short_code%Type ;

Line 1150: g_cwb_per_group_pl_id ben_per_in_ler.group_pl_id%type ;

1146: --cwb variables
1147: --- intialize cwb globals
1148: g_cwb_group_plan_name ben_pl_f.name%type ;
1149: g_cwb_per_group_per_in_ler_id ben_cwb_person_info.group_per_in_ler_id%type ;
1150: g_cwb_per_group_pl_id ben_per_in_ler.group_pl_id%type ;
1151: g_CWB_Person_FULL_NAME ben_cwb_person_info.FULL_NAME%type ;
1152: g_CWB_Person_Custom_Name ben_cwb_person_info.Custom_Name%type ;
1153: g_CWB_Person_Brief_Name ben_cwb_person_info.Brief_Name%type ;
1154: g_CWB_Life_Event_Name ben_ler_f.name%type ;

Line 1156: g_CWB_Life_Event_Occurred_Date ben_per_in_ler.LF_EVT_OCRD_DT%type ;

1152: g_CWB_Person_Custom_Name ben_cwb_person_info.Custom_Name%type ;
1153: g_CWB_Person_Brief_Name ben_cwb_person_info.Brief_Name%type ;
1154: g_CWB_Life_Event_Name ben_ler_f.name%type ;
1155: g_CWB_Life_Event_status ben_ler_f.name%type ;
1156: g_CWB_Life_Event_Occurred_Date ben_per_in_ler.LF_EVT_OCRD_DT%type ;
1157: g_CWB_Person_EMAIL_DDRESS ben_cwb_person_info.EMAIL_ADDRESS%type ;
1158: g_CWB_Person_EMPLOYEE_NUMBER ben_cwb_person_info.EMPLOYEE_NUMBER%Type ;
1159: g_CWB_Person_BASE_SALARY ben_cwb_person_info.BASE_SALARY%type ;
1160: g_CWB_Person_BG_Name per_business_groups.name%type ;