APPS.HR_PAYMENTS dependencies on PAY_PAYMENT_TYPES

Line 15: PAY_PAYMENT_TYPES

11: NAME
12: hr_payments (hrppm.pkb)
13: NOTES
14: per-payments procedures. Used for validation of DDL on:
15: PAY_PAYMENT_TYPES
16: PAY_ORG_PAYMENT_METHODS
17: PAY_ORG_PAY_METHOD_USAGES
18: PAY_PERSONAL_PAYMENT_METHODS
19: MODIFIED

Line 46: Validate business rules for pay_payment_types

42:
43: NAME
44: validate_magnetic
45: DESCRIPTION
46: Validate business rules for pay_payment_types
47: NOTES
48: Category is magnetic if this is called.
49: Check pre-validation_requied flag is set.
50: If pre-validation, check that the values and days are set.

Line 122: pay_payment_types trigger

118: /*--------------------------- ppt_brui -----------------------------------
119: NAME
120: ppt_brui
121: DESCRIPTION
122: pay_payment_types trigger
123: NOTES
124: Calls various validation routines on new/updated row
125: */
126: procedure ppt_brui(allow_as_default in varchar2,

Line 176: from pay_payment_types ppt,

172: select ppt.territory_code,
173: exa.territory_code
174: into required_territory,
175: actual_territory
176: from pay_payment_types ppt,
177: pay_external_accounts exa
178: where exa.external_account_id = account
179: and ppt.payment_type_id = type;
180: --

Line 229: from pay_payment_types ppt

225: hr_utility.set_location('HR_PAYMENTS.CHECK_CURRENCY',1);
226: --
227: select ppt.currency_code
228: into required_currency
229: from pay_payment_types ppt
230: where ppt.payment_type_id = type;
231: --
232: -- Check that they are the same. If not report the error
233: --

Line 589: from pay_payment_types ppt,

585: select nvl(ppt.territory_code, 'NONE'),
586: ppt.category
587: into required_territory,
588: category
589: from pay_payment_types ppt,
590: pay_org_payment_methods_f opm
591: where opm.org_payment_method_id = opm_id
592: and opm.payment_type_id = ppt.payment_type_id
593: and fnd_date.canonical_to_date(val_start_date) between