DBA Data[Home] [Help]

APPS.BEN_EXT_PERSON dependencies on BEN_PER_IN_LER

Line 276: g_per_in_ler_id ben_per_in_ler.per_in_ler_id%TYPE;

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

Line 279: g_lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%TYPE;

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

Line 280: g_lf_evt_note_dt ben_per_in_ler.ntfn_dt%TYPE;

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

Line 482: g_enrt_lfevt_status ben_per_in_ler.per_in_ler_stat_cd%TYPE;

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

Line 483: g_enrt_lfevt_note_dt ben_per_in_ler.ntfn_dt%TYPE;

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

Line 484: g_enrt_lfevt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%TYPE;

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

Line 716: g_cm_lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%TYPE;

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

Line 719: g_cm_lf_evt_stat ben_per_in_ler.per_in_ler_stat_cd%TYPE;

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

Line 720: g_cm_lf_evt_ntfn_dt ben_per_in_ler.ntfn_dt%TYPE;

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

Line 916: g_elig_lfevt_status ben_per_in_ler.per_in_ler_stat_cd%TYPE;

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

Line 917: g_elig_lfevt_note_dt ben_per_in_ler.ntfn_dt%TYPE;

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

Line 918: g_elig_lfevt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%TYPE;

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

Line 1147: g_cwb_per_group_pl_id ben_per_in_ler.group_pl_id%type ;

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

Line 1153: g_CWB_Life_Event_Occurred_Date ben_per_in_ler.LF_EVT_OCRD_DT%type ;

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