APPS.PAY_OPM_BUS dependencies on PAY_PAYMENT_TYPES

Line 805: from pay_payment_types pty

801: from pay_external_accounts exa
802: where exa.external_account_id = p_external_account_id
803: and exists
804: (select null
805: from pay_payment_types pty
806: where pty.payment_type_id = p_payment_type_id
807: and ((pty.territory_code is not null
808: and pty.territory_code = exa.territory_code)
809: or (pty.territory_code is null

Line 819: pay_payment_types pyt

815: --
816: cursor csr_ext_chk is
817: select count (*)
818: from pay_org_payment_methods_f pop,
819: pay_payment_types pyt
820: where pop.payment_type_id = pyt.payment_type_id
821: and pyt.category =
822: ( select pyt.category
823: from pay_payment_types pyt

Line 823: from pay_payment_types pyt

819: pay_payment_types pyt
820: where pop.payment_type_id = pyt.payment_type_id
821: and pyt.category =
822: ( select pyt.category
823: from pay_payment_types pyt
824: where pyt.payment_type_id = p_payment_type_id)
825: and (p_org_payment_method_id is null
826: or pop.org_payment_method_id <> p_org_payment_method_id )
827: and pop.external_account_id is not null

Line 955: from pay_payment_types pty

951: and p_effective_date between nvl(start_date_active,p_effective_date)
952: and nvl(end_date_active,p_effective_date)
953: and exists
954: (select null
955: from pay_payment_types pty
956: where pty.payment_type_id = p_payment_type_id
957: and (pty.currency_code is null
958: or (pty.currency_code is not null
959: and pty.currency_code = p_currency_code)));

Line 1030: -- row on the parent PAY_PAYMENT_TYPES table.

1026: -- ----------------------------------------------------------------------------
1027: --
1028: -- Description:
1029: -- Check that the payment_type_id is not null and that it refers to a
1030: -- row on the parent PAY_PAYMENT_TYPES table.
1031: -- Also cross validate whether this is a valid Payment Type for the
1032: -- business group.
1033: --
1034: -- Pre-Requisites:

Line 1063: from pay_payment_types pyt

1059: l_dummy number;
1060: --
1061: cursor csr_pay_type_id_exists is
1062: select null
1063: from pay_payment_types pyt
1064: where pyt.payment_type_id = p_payment_type_id
1065: and ((pyt.territory_code is null)
1066: or exists
1067: (select null

Line 1073: from pay_payment_types pyt2,

1069: where lgr.legislation_code = pyt.territory_code
1070: and lgr.rule_type = 'E'))
1071: and not exists
1072: (select 'x'
1073: from pay_payment_types pyt2,
1074: per_business_groups pbg
1075: where pyt2.category = pyt.category
1076: and pbg.business_group_id = p_business_group_id
1077: and pyt2.territory_code = pbg.legislation_code

Line 1108: -- Check payment_type_id is a valid entry within PAY_PAYMENT_TYPES.

1104: if (p_org_payment_method_id is null) then
1105: --
1106: hr_utility.set_location(l_proc,20);
1107: --
1108: -- Check payment_type_id is a valid entry within PAY_PAYMENT_TYPES.
1109: --
1110: open csr_pay_type_id_exists;
1111: fetch csr_pay_type_id_exists into l_dummy;
1112: if csr_pay_type_id_exists%notfound then