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_PERSONAL_PAYMENT_METHODS_F

Line 39: pay_personal_payment_methods_f.org_payment_method_id%type

35: -- Internal Table Handler Use Only.
36: --
37: function balance_remunerative
38: (p_org_payment_method_id in
39: pay_personal_payment_methods_f.org_payment_method_id%type
40: ,p_effective_date in date
41: )
42: return boolean is
43: --

Line 322: from pay_personal_payment_methods_f ppm

318: return date is
319: --
320: cursor ppm_sel is
321: select ppm.effective_start_date -1
322: from pay_personal_payment_methods_f ppm
323: where ppm.assignment_id = p_assignment_id
324: and ppm.priority = p_priority
325: and nvl(ppm.run_type_id,-9999) = nvl(p_run_type_id,-9999)
326: and (ppm.priority <> 1

Line 345: from pay_personal_payment_methods_f ppm2

341: p_personal_payment_method_id
342: or p_personal_payment_method_id is null)
343: and ppm.effective_start_date =
344: (select min(ppm2.effective_start_date)
345: from pay_personal_payment_methods_f ppm2
346: where (ppm2.personal_payment_method_id <>
347: p_personal_payment_method_id
348: or p_personal_payment_method_id is null)
349: and ppm2.assignment_id = p_assignment_id

Line 886: pay_personal_payment_methods_f.amount%TYPE

882: -- ---------------------------------------------------------------------------
883: --
884: procedure chk_amount_percent
885: (p_amount in
886: pay_personal_payment_methods_f.amount%TYPE
887: ,p_percentage in
888: pay_personal_payment_methods_f.percentage%TYPE
889: ,p_personal_payment_method_id in
890: pay_personal_payment_methods_f.personal_payment_method_id%TYPE

Line 888: pay_personal_payment_methods_f.percentage%TYPE

884: procedure chk_amount_percent
885: (p_amount in
886: pay_personal_payment_methods_f.amount%TYPE
887: ,p_percentage in
888: pay_personal_payment_methods_f.percentage%TYPE
889: ,p_personal_payment_method_id in
890: pay_personal_payment_methods_f.personal_payment_method_id%TYPE
891: ,p_org_payment_method_id in
892: pay_personal_payment_methods_f.org_payment_method_id%TYPE

Line 890: pay_personal_payment_methods_f.personal_payment_method_id%TYPE

886: pay_personal_payment_methods_f.amount%TYPE
887: ,p_percentage in
888: pay_personal_payment_methods_f.percentage%TYPE
889: ,p_personal_payment_method_id in
890: pay_personal_payment_methods_f.personal_payment_method_id%TYPE
891: ,p_org_payment_method_id in
892: pay_personal_payment_methods_f.org_payment_method_id%TYPE
893: ,p_effective_date in date
894: ,p_object_version_number in

Line 892: pay_personal_payment_methods_f.org_payment_method_id%TYPE

888: pay_personal_payment_methods_f.percentage%TYPE
889: ,p_personal_payment_method_id in
890: pay_personal_payment_methods_f.personal_payment_method_id%TYPE
891: ,p_org_payment_method_id in
892: pay_personal_payment_methods_f.org_payment_method_id%TYPE
893: ,p_effective_date in date
894: ,p_object_version_number in
895: pay_personal_payment_methods_f.object_version_number%TYPE) is
896: --

Line 895: pay_personal_payment_methods_f.object_version_number%TYPE) is

891: ,p_org_payment_method_id in
892: pay_personal_payment_methods_f.org_payment_method_id%TYPE
893: ,p_effective_date in date
894: ,p_object_version_number in
895: pay_personal_payment_methods_f.object_version_number%TYPE) is
896: --
897: l_exists varchar2(1);
898: l_proc varchar2(72) := g_package||'chk_amount_percent';
899: l_api_updating boolean;

Line 1049: pay_personal_payment_methods_f.personal_payment_method_id%TYPE

1045: -- ---------------------------------------------------------------------------
1046: --
1047: procedure chk_external_account_id
1048: (p_personal_payment_method_id in
1049: pay_personal_payment_methods_f.personal_payment_method_id%TYPE
1050: ,p_org_payment_method_id in
1051: pay_personal_payment_methods_f.org_payment_method_id%TYPE
1052: ,p_external_account_id in number
1053: ,p_effective_date in date

Line 1051: pay_personal_payment_methods_f.org_payment_method_id%TYPE

1047: procedure chk_external_account_id
1048: (p_personal_payment_method_id in
1049: pay_personal_payment_methods_f.personal_payment_method_id%TYPE
1050: ,p_org_payment_method_id in
1051: pay_personal_payment_methods_f.org_payment_method_id%TYPE
1052: ,p_external_account_id in number
1053: ,p_effective_date in date
1054: ,p_object_version_number in
1055: pay_personal_payment_methods_f.object_version_number%TYPE) is

Line 1055: pay_personal_payment_methods_f.object_version_number%TYPE) is

1051: pay_personal_payment_methods_f.org_payment_method_id%TYPE
1052: ,p_external_account_id in number
1053: ,p_effective_date in date
1054: ,p_object_version_number in
1055: pay_personal_payment_methods_f.object_version_number%TYPE) is
1056: --
1057: l_exists varchar2(1);
1058: l_proc varchar2(72) := g_package||'chk_external_account_id';
1059: l_api_updating boolean;

Line 1202: pay_personal_payment_methods_f.priority%TYPE

1198: -- ---------------------------------------------------------------------------
1199: --
1200: procedure chk_priority
1201: (p_priority in
1202: pay_personal_payment_methods_f.priority%TYPE
1203: ,p_personal_payment_method_id in
1204: pay_personal_payment_methods_f.personal_payment_method_id%TYPE
1205: ,p_org_payment_method_id in
1206: pay_personal_payment_methods_f.org_payment_method_id%TYPE

Line 1204: pay_personal_payment_methods_f.personal_payment_method_id%TYPE

1200: procedure chk_priority
1201: (p_priority in
1202: pay_personal_payment_methods_f.priority%TYPE
1203: ,p_personal_payment_method_id in
1204: pay_personal_payment_methods_f.personal_payment_method_id%TYPE
1205: ,p_org_payment_method_id in
1206: pay_personal_payment_methods_f.org_payment_method_id%TYPE
1207: ,p_assignment_id in
1208: pay_personal_payment_methods_f.assignment_id%TYPE

Line 1206: pay_personal_payment_methods_f.org_payment_method_id%TYPE

1202: pay_personal_payment_methods_f.priority%TYPE
1203: ,p_personal_payment_method_id in
1204: pay_personal_payment_methods_f.personal_payment_method_id%TYPE
1205: ,p_org_payment_method_id in
1206: pay_personal_payment_methods_f.org_payment_method_id%TYPE
1207: ,p_assignment_id in
1208: pay_personal_payment_methods_f.assignment_id%TYPE
1209: ,p_run_type_id in
1210: pay_personal_payment_methods_f.run_type_id%TYPE

Line 1208: pay_personal_payment_methods_f.assignment_id%TYPE

1204: pay_personal_payment_methods_f.personal_payment_method_id%TYPE
1205: ,p_org_payment_method_id in
1206: pay_personal_payment_methods_f.org_payment_method_id%TYPE
1207: ,p_assignment_id in
1208: pay_personal_payment_methods_f.assignment_id%TYPE
1209: ,p_run_type_id in
1210: pay_personal_payment_methods_f.run_type_id%TYPE
1211: ,p_effective_date in date
1212: ,p_object_version_number in

Line 1210: pay_personal_payment_methods_f.run_type_id%TYPE

1206: pay_personal_payment_methods_f.org_payment_method_id%TYPE
1207: ,p_assignment_id in
1208: pay_personal_payment_methods_f.assignment_id%TYPE
1209: ,p_run_type_id in
1210: pay_personal_payment_methods_f.run_type_id%TYPE
1211: ,p_effective_date in date
1212: ,p_object_version_number in
1213: pay_personal_payment_methods_f.object_version_number%TYPE
1214: ,p_validation_start_date in date

Line 1213: pay_personal_payment_methods_f.object_version_number%TYPE

1209: ,p_run_type_id in
1210: pay_personal_payment_methods_f.run_type_id%TYPE
1211: ,p_effective_date in date
1212: ,p_object_version_number in
1213: pay_personal_payment_methods_f.object_version_number%TYPE
1214: ,p_validation_start_date in date
1215: ,p_validation_end_date in date) is
1216: --
1217: l_exists varchar2(1);

Line 1227: from pay_personal_payment_methods_f ppm

1223: -- methods in the check.
1224:
1225: cursor csr_check_unique is
1226: select null
1227: from pay_personal_payment_methods_f ppm
1228: where ppm.priority = p_priority
1229: and ppm.assignment_id = p_assignment_id
1230: and nvl(ppm.run_type_id,-9999) = nvl(p_run_type_id,-9999)
1231: and (ppm.personal_payment_method_id <> p_personal_payment_method_id

Line 1349: -- Validates that rows may be deleted from pay_personal_payment_methods_f

1345: -- |------------------------< chk_delete >----------------------------|
1346: -- ---------------------------------------------------------------------------
1347: --
1348: -- Description:
1349: -- Validates that rows may be deleted from pay_personal_payment_methods_f
1350: --
1351: -- Pre-conditions:
1352: -- None
1353: --

Line 1385: pay_personal_payment_methods_f.personal_payment_method_id%TYPE

1381: -- Internal Table Handler Use Only.
1382: --
1383: procedure chk_delete
1384: (p_personal_payment_method_id in
1385: pay_personal_payment_methods_f.personal_payment_method_id%TYPE
1386: ,p_effective_date in date
1387: ,p_datetrack_mode in varchar2
1388: ,p_validation_start_date in date
1389: ,p_validation_end_date in date) is

Line 1421: from pay_personal_payment_methods_f ppm,

1417: -- payment method is referenced by at least one element entry.
1418: --
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

Line 2023: , pay_personal_payment_methods_f ppm

2019: --
2020: cursor csr_leg_code is
2021: select pbg.legislation_code
2022: from per_business_groups pbg
2023: , pay_personal_payment_methods_f ppm
2024: where ppm.personal_payment_method_id = p_personal_payment_method_id
2025: and pbg.business_group_id = ppm.business_group_id;
2026: --
2027: -- Declare local variables