eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_PPM_BUS dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 53: pay_org_payment_methods_f opm

49: cursor csr_chk_blt is
50: select null
51: from pay_balance_types blt,
52: pay_defined_balances dfb,
53: pay_org_payment_methods_f opm
54: where blt.assignment_remuneration_flag = 'Y'
55: and blt.balance_type_id = dfb.balance_type_id
56: and dfb.defined_balance_id = opm.defined_balance_id
57: and opm.org_payment_method_id = p_org_payment_method_id

Line 130: from pay_org_payment_methods_f opm

126: return date is
127: --
128: cursor csr_check_org_method is
129: select 1
130: from pay_org_payment_methods_f opm
131: where opm.org_payment_method_id = p_org_payment_method_id
132: and p_effective_date
133: between opm.effective_start_date
134: and opm.effective_end_date;

Line 329: from pay_org_payment_methods_f opm

325: and nvl(ppm.run_type_id,-9999) = nvl(p_run_type_id,-9999)
326: and (ppm.priority <> 1
327: or exists
328: (select null
329: from pay_org_payment_methods_f opm
330: , pay_defined_balances db
331: , pay_balance_types bt
332: where opm.org_payment_method_id = ppm.org_payment_method_id
333: and p_effective_date between

Line 355: from pay_org_payment_methods_f opm

351: and nvl(ppm2.run_type_id,-9999) = nvl(p_run_type_id,-9999)
352: and (ppm2.priority <> 1
353: or exists
354: (select null
355: from pay_org_payment_methods_f opm
356: , pay_defined_balances db
357: , pay_balance_types bt
358: where opm.org_payment_method_id = ppm2.org_payment_method_id
359: and p_effective_date between

Line 546: from pay_org_payment_methods_f opm,

542: --
543: -- Bug 4644507. Removed the usage of per_business_groups from the cursor.
544: cursor csr_is_valid is
545: select null
546: from pay_org_payment_methods_f opm,
547: pay_payment_types ppt
548: where opm.org_payment_method_id = p_org_payment_method_id
549: and p_effective_date
550: between opm.effective_start_date

Line 605: from pay_org_payment_methods_f opm

601: -- Check if the personal payment method is a garnishment.
602: --
603: cursor csr_chk_garnishment is
604: select null
605: from pay_org_payment_methods_f opm
606: where opm.org_payment_method_id = p_org_payment_method_id
607: and p_effective_date between opm.effective_start_date
608: and opm.effective_end_date
609: and opm.defined_balance_id is null;

Line 615: from pay_org_payment_methods_f opm

611: -- Check the category of the payment.
612: --
613: cursor csr_chk_pay_type is
614: select pyt.category
615: from pay_org_payment_methods_f opm
616: , pay_payment_types pyt
617: where p_org_payment_method_id = opm.org_payment_method_id
618: and opm.payment_type_id = pyt.payment_type_id
619: and p_effective_date between opm.effective_start_date

Line 907: from pay_org_payment_methods_f opm

903: --
904: -- Currency code for monetary amount comes from the balance.
905: cursor get_curcode is
906: select bt.currency_code
907: from pay_org_payment_methods_f opm
908: , pay_defined_balances db
909: , pay_balance_types bt
910: where org_payment_method_id = p_org_payment_method_id
911: and p_effective_date between

Line 1065: from pay_org_payment_methods_f opm

1061: -- Check if related payment type is Magnetic Tape
1062: --
1063: cursor csr_chk_pay_type is
1064: select null
1065: from pay_org_payment_methods_f opm
1066: , pay_payment_types pyt
1067: where p_org_payment_method_id = opm.org_payment_method_id
1068: and opm.payment_type_id = pyt.payment_type_id
1069: and p_effective_date between opm.effective_start_date

Line 1087: pay_org_payment_methods_f opm

1083: cursor chk_org_flex_struct is
1084: select null
1085: from pay_external_accounts pea1,
1086: pay_external_accounts pea2,
1087: pay_org_payment_methods_f opm
1088: where pea1.external_account_id = p_external_account_id
1089: and opm.org_payment_method_id = p_org_payment_method_id
1090: and opm.external_account_id = pea2.external_account_id
1091: and pea1.id_flex_num = pea2.id_flex_num

Line 1236: from pay_org_payment_methods_f opm

1232: or p_personal_payment_method_id is null)
1233: and (ppm.priority <> 1
1234: or exists
1235: (select null
1236: from pay_org_payment_methods_f opm
1237: , pay_defined_balances db
1238: , pay_balance_types bt
1239: where opm.org_payment_method_id = ppm.org_payment_method_id
1240: and p_effective_date between

Line 1423: pay_org_payment_methods_f opm

1419: cursor csr_del_garnishment is
1420: select null
1421: from pay_personal_payment_methods_f ppm,
1422: pay_element_entries_f ele,
1423: pay_org_payment_methods_f opm
1424: where ppm.personal_payment_method_id = p_personal_payment_method_id
1425: and p_effective_date between ppm.effective_start_date
1426: and ppm.effective_end_date
1427: and ppm.org_payment_method_id = opm.org_payment_method_id

Line 1635: (p_base_table_name => 'pay_org_payment_methods_f',

1631: p_argument_value => p_validation_end_date);
1632: --
1633: If ((nvl(p_org_payment_method_id, hr_api.g_number) <> hr_api.g_number) and
1634: NOT (dt_api.check_min_max_dates
1635: (p_base_table_name => 'pay_org_payment_methods_f',
1636: p_base_key_column => 'org_payment_method_id',
1637: p_base_key_value => p_org_payment_method_id,
1638: p_from_date => p_validation_start_date,
1639: p_to_date => p_validation_end_date))) Then