APPS.PAY_ROM_BUS dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 473: from pay_org_payment_methods_f opm

469: l_proc varchar2(72) := g_package||'chk_org_payment_method_id';
470: --
471: CURSOR csr_chk_org_pay_method is
472: select 'Y'
473: from pay_org_payment_methods_f opm
474: where opm.org_payment_method_id = p_org_payment_method_id
475: and p_effective_date between opm.effective_start_date
476: and opm.effective_end_date
477: and opm.business_group_id = p_business_group_id;

Line 722: from pay_org_payment_methods_f

718: --
719: cursor get_curcode
720: is
721: select currency_code
722: from pay_org_payment_methods_f
723: where org_payment_method_id = p_org_payment_method_id;
724: --
725: BEGIN
726: hr_utility.set_location('Entering: '||l_proc, 5);

Line 947: (p_base_table_name => 'pay_org_payment_methods_f'

943: );
944: --
945: If ((nvl(p_org_payment_method_id, hr_api.g_number) <> hr_api.g_number) and
946: NOT (dt_api.check_min_max_dates
947: (p_base_table_name => 'pay_org_payment_methods_f'
948: ,p_base_key_column => 'ORG_PAYMENT_METHOD_ID'
949: ,p_base_key_value => p_org_payment_method_id
950: ,p_from_date => p_validation_start_date
951: ,p_to_date => p_validation_end_date))) Then