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 51: Validate business rules for pay_payment_types

47:
48: NAME
49: validate_magnetic
50: DESCRIPTION
51: Validate business rules for pay_payment_types
52: NOTES
53: Category is magnetic if this is called.
54: Check pre-validation_requied flag is set.
55: If pre-validation, check that the values and days are set.

Line 127: pay_payment_types trigger

123: /*--------------------------- ppt_brui -----------------------------------
124: NAME
125: ppt_brui
126: DESCRIPTION
127: pay_payment_types trigger
128: NOTES
129: Calls various validation routines on new/updated row
130: */
131: procedure ppt_brui(allow_as_default in varchar2,

Line 181: from pay_payment_types ppt,

177: select ppt.territory_code,
178: exa.territory_code
179: into required_territory,
180: actual_territory
181: from pay_payment_types ppt,
182: pay_external_accounts exa
183: where exa.external_account_id = account
184: and ppt.payment_type_id = type;
185: --

Line 234: from pay_payment_types ppt

230: hr_utility.set_location('HR_PAYMENTS.CHECK_CURRENCY',1);
231: --
232: select ppt.currency_code
233: into required_currency
234: from pay_payment_types ppt
235: where ppt.payment_type_id = type;
236: --
237: -- Check that they are the same. If not report the error
238: --

Line 594: from pay_payment_types ppt,

590: select nvl(ppt.territory_code, 'NONE'),
591: ppt.category
592: into required_territory,
593: category
594: from pay_payment_types ppt,
595: pay_org_payment_methods_f opm
596: where opm.org_payment_method_id = opm_id
597: and opm.payment_type_id = ppt.payment_type_id
598: and fnd_date.canonical_to_date(val_start_date) between