DBA Data[Home] [Help]

APPS.PAY_KR_PROCESS_NAV_PKG dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 103: l_payment_method_override_name PAY_ORG_PAYMENT_METHODS_F.org_payment_method_name%TYPE ;

99: l_retro_assignment_set_name hr_assignment_sets.assignment_set_name%TYPE ;
100: l_retro_element_set_name pay_element_sets.element_set_name%TYPE ;
101: l_element_set_name pay_element_sets.element_set_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 ;

Line 104: l_payment_method_name PAY_ORG_PAYMENT_METHODS_F.org_payment_method_name%TYPE ;

100: l_retro_element_set_name pay_element_sets.element_set_name%TYPE ;
101: l_element_set_name pay_element_sets.element_set_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 ;

Line 181: from pay_org_payment_methods_f_tl

177: where run_type_id = p_run_type_id;
178: --
179: cursor csr_payment_method (p_pay_method in number) is
180: select org_payment_method_name
181: from pay_org_payment_methods_f_tl
182: where org_payment_method_id = p_pay_method
183: and language = userenv('LANG') ;
184: --
185: cursor csr_business_place_name is