DBA Data[Home] [Help]

APPS.PAY_KR_PROCESS_NAV_PKG dependencies on PAY_EVENT_GROUPS

Line 106: l_retro_notf_event_group_name pay_event_groups.event_group_name%TYPE ;

102: l_assignment_set_name hr_assignment_sets.assignment_set_name%TYPE ;
103: l_payment_method_override_name PAY_ORG_PAYMENT_METHODS_F.org_payment_method_name%TYPE ;
104: l_payment_method_name PAY_ORG_PAYMENT_METHODS_F.org_payment_method_name%TYPE ;
105: l_business_place_name hr_all_organization_units.name%TYPE ;
106: l_retro_notf_event_group_name pay_event_groups.event_group_name%TYPE ;
107: l_sort_order1_disp hr_lookups.meaning%TYPE ;
108: l_sort_order2_disp hr_lookups.meaning%TYPE ;
109: l_eff_date_retro_notf_disp varchar2(200) ;
110: l_run_type_period_name_disp varchar2(400) ;

Line 214: from pay_event_groups

210: and language = userenv('LANG') ;
211: --
212: cursor csr_event_group_name is
213: select event_group_name
214: from pay_event_groups
215: where event_group_id = to_number(substr(p_event_group, 12)) ;
216: --
217: cursor csr_run_type_period_name is
218: select run_type_name||'-'||ptp.period_name||'-'||ppa.payroll_action_id run_type_period_name