APPS.PAY_PAY_BUS dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 723: (p_base_table_name => 'pay_org_payment_methods_f'

719: );
720: --
721: If ((nvl(p_org_payment_method_id, hr_api.g_number) <> hr_api.g_number) and
722: NOT (dt_api.check_min_max_dates
723: (p_base_table_name => 'pay_org_payment_methods_f'
724: ,p_base_key_column => 'ORG_PAYMENT_METHOD_ID'
725: ,p_base_key_value => p_org_payment_method_id
726: ,p_from_date => p_validation_start_date
727: ,p_to_date => p_validation_end_date))) Then

Line 919: from pay_org_payment_methods_f opm

915: --
916: cursor csr_chk_parent is
917: select opm.effective_start_date
918: ,opm.effective_end_date
919: from pay_org_payment_methods_f opm
920: where opm.org_payment_method_id = p_default_payment_method_id
921: order by opm.effective_start_date
922: for update;
923: --

Line 926: from pay_org_payment_methods_f opm, pay_payment_types pt

922: for update;
923: --
924: cursor csr_pay_catg_ass_remun is
925: select null
926: from pay_org_payment_methods_f opm, pay_payment_types pt
927: ,pay_defined_balances dfb, pay_balance_types bt
928: where opm.org_payment_method_id = p_default_payment_method_id
929: and opm.business_group_id +0 = p_business_group_id
930: and pt.payment_type_id = opm.payment_type_id

Line 952: -- Payment method must exist in PAY_ORG_PAYMENT_METHODS_F

948: exit when csr_chk_parent%notfound;
949: end loop;
950: close csr_chk_parent;
951: --
952: -- Payment method must exist in PAY_ORG_PAYMENT_METHODS_F
953: --
954: if v_count = 0 then
955: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
956: fnd_message.set_token('COLUMN','DEFAULT_PAYMENT_METHOD_ID');

Line 957: fnd_message.set_token('TABLE','PAY_ORG_PAYMENT_METHODS_F');

953: --
954: if v_count = 0 then
955: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
956: fnd_message.set_token('COLUMN','DEFAULT_PAYMENT_METHOD_ID');
957: fnd_message.set_token('TABLE','PAY_ORG_PAYMENT_METHODS_F');
958: fnd_message.raise_error;
959: end if;
960: --
961: -- Payment method must be valid for the lifetime of payroll