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.HR_PERSONAL_PAY_METHOD_API dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 156: pay_personal_payment_methods_f.personal_payment_method_id%type

152: -- {End Of Comments}
153: --
154: procedure check_update_legislation
155: (p_personal_payment_method_id in
156: pay_personal_payment_methods_f.personal_payment_method_id%type
157: ,p_effective_date in date
158: ,p_leg_code in varchar2
159: ) is
160: --

Line 169: pay_personal_payment_methods_f ppm

165: --
166: cursor legsel is
167: select pbg.legislation_code
168: from per_business_groups pbg,
169: pay_personal_payment_methods_f ppm
170: where pbg.business_group_id = ppm.business_group_id
171: and ppm.personal_payment_method_id = p_personal_payment_method_id
172: and p_effective_date between ppm.effective_start_date
173: and ppm.effective_end_date;

Line 262: from pay_personal_payment_methods_f ppm

258: ,p_effective_date in date
259: ) is
260: select nvl(to_char(opm.defined_balance_id), 'Y') third_party
261: , nvl(ppt.validation_days, 0) validation_days
262: from pay_personal_payment_methods_f ppm
263: , pay_org_payment_methods_f opm
264: , pay_payment_types ppt
265: where ppm.personal_payment_method_id = p_personal_payment_method_id
266: and p_effective_date between

Line 281: from pay_personal_payment_methods_f ppm

277: (p_personal_payment_method_id in number
278: ,p_effective_date in date
279: ) is
280: select nvl(pap.prl_information3, 'Y') prenote_allowed
281: from pay_personal_payment_methods_f ppm
282: , per_all_assignments_f paa
283: , pay_all_payrolls_f pap
284: where ppm.personal_payment_method_id = p_personal_payment_method_id
285: and p_effective_date between

Line 471: from pay_personal_payment_methods_f ppm

467: cursor csr_payroll_details(p_personal_payment_method_id in number
468: ,p_effective_date in date
469: ) is
470: select nvl(pap.prl_information3, 'Y') prenote_allowed
471: from pay_personal_payment_methods_f ppm
472: , per_all_assignments_f paa
473: , pay_all_payrolls_f pap
474: where ppm.personal_payment_method_id = p_personal_payment_method_id
475: and p_effective_date between

Line 660: l_external_account_id pay_personal_payment_methods_f.external_account_id%TYPE;

656: -- Declare cursors and local variables
657: --
658: l_proc varchar2(72);
659: l_business_group_id per_assignments_f.business_group_id%TYPE;
660: l_external_account_id pay_personal_payment_methods_f.external_account_id%TYPE;
661: l_validate boolean := FALSE;
662: l_exa_ovn number;
663: l_exists varchar2(1);
664: l_category varchar2(2);

Line 666: l_ppm_information_category pay_personal_payment_methods_f.ppm_information_category%TYPE;

662: l_exa_ovn number;
663: l_exists varchar2(1);
664: l_category varchar2(2);
665: l_effective_date date;
666: l_ppm_information_category pay_personal_payment_methods_f.ppm_information_category%TYPE;
667: --
668: -- Declare OUT variables.
669: --
670: l_personal_payment_method_id pay_personal_payment_methods_f.personal_payment_method_id%TYPE;

Line 670: l_personal_payment_method_id pay_personal_payment_methods_f.personal_payment_method_id%TYPE;

666: l_ppm_information_category pay_personal_payment_methods_f.ppm_information_category%TYPE;
667: --
668: -- Declare OUT variables.
669: --
670: l_personal_payment_method_id pay_personal_payment_methods_f.personal_payment_method_id%TYPE;
671: l_object_version_number pay_personal_payment_methods_f.object_version_number%TYPE;
672: l_effective_start_date pay_personal_payment_methods_f.effective_start_date%TYPE;
673: l_effective_end_date pay_personal_payment_methods_f.effective_end_date%TYPE;
674: l_comment_id pay_personal_payment_methods_f.comment_id%TYPE;

Line 671: l_object_version_number pay_personal_payment_methods_f.object_version_number%TYPE;

667: --
668: -- Declare OUT variables.
669: --
670: l_personal_payment_method_id pay_personal_payment_methods_f.personal_payment_method_id%TYPE;
671: l_object_version_number pay_personal_payment_methods_f.object_version_number%TYPE;
672: l_effective_start_date pay_personal_payment_methods_f.effective_start_date%TYPE;
673: l_effective_end_date pay_personal_payment_methods_f.effective_end_date%TYPE;
674: l_comment_id pay_personal_payment_methods_f.comment_id%TYPE;
675: --

Line 672: l_effective_start_date pay_personal_payment_methods_f.effective_start_date%TYPE;

668: -- Declare OUT variables.
669: --
670: l_personal_payment_method_id pay_personal_payment_methods_f.personal_payment_method_id%TYPE;
671: l_object_version_number pay_personal_payment_methods_f.object_version_number%TYPE;
672: l_effective_start_date pay_personal_payment_methods_f.effective_start_date%TYPE;
673: l_effective_end_date pay_personal_payment_methods_f.effective_end_date%TYPE;
674: l_comment_id pay_personal_payment_methods_f.comment_id%TYPE;
675: --
676: cursor bgsel is

Line 673: l_effective_end_date pay_personal_payment_methods_f.effective_end_date%TYPE;

669: --
670: l_personal_payment_method_id pay_personal_payment_methods_f.personal_payment_method_id%TYPE;
671: l_object_version_number pay_personal_payment_methods_f.object_version_number%TYPE;
672: l_effective_start_date pay_personal_payment_methods_f.effective_start_date%TYPE;
673: l_effective_end_date pay_personal_payment_methods_f.effective_end_date%TYPE;
674: l_comment_id pay_personal_payment_methods_f.comment_id%TYPE;
675: --
676: cursor bgsel is
677: select pa.business_group_id

Line 674: l_comment_id pay_personal_payment_methods_f.comment_id%TYPE;

670: l_personal_payment_method_id pay_personal_payment_methods_f.personal_payment_method_id%TYPE;
671: l_object_version_number pay_personal_payment_methods_f.object_version_number%TYPE;
672: l_effective_start_date pay_personal_payment_methods_f.effective_start_date%TYPE;
673: l_effective_end_date pay_personal_payment_methods_f.effective_end_date%TYPE;
674: l_comment_id pay_personal_payment_methods_f.comment_id%TYPE;
675: --
676: cursor bgsel is
677: select pa.business_group_id
678: from per_assignments_f pa

Line 2102: pay_personal_payment_methods_f.external_account_id%TYPE;

2098: l_proc varchar2(72);
2099: l_business_group_id per_assignments_f.business_group_id%TYPE;
2100: l_validate boolean := FALSE;
2101: l_external_account_id
2102: pay_personal_payment_methods_f.external_account_id%TYPE;
2103: l_object_version_number
2104: pay_external_accounts.object_version_number%TYPE;
2105: l_exa_ovn number;
2106: l_effective_date date;

Line 2107: l_ppm_information_category pay_personal_payment_methods_f.ppm_information_category%TYPE;

2103: l_object_version_number
2104: pay_external_accounts.object_version_number%TYPE;
2105: l_exa_ovn number;
2106: l_effective_date date;
2107: l_ppm_information_category pay_personal_payment_methods_f.ppm_information_category%TYPE;
2108: --
2109: -- Declare OUT variables
2110: --
2111: l_comment_id

Line 2112: pay_personal_payment_methods_f.comment_id%TYPE;

2108: --
2109: -- Declare OUT variables
2110: --
2111: l_comment_id
2112: pay_personal_payment_methods_f.comment_id%TYPE;
2113: l_effective_start_date
2114: pay_personal_payment_methods_f.effective_start_date%TYPE;
2115: l_effective_end_date
2116: pay_personal_payment_methods_f.effective_end_date%TYPE;

Line 2114: pay_personal_payment_methods_f.effective_start_date%TYPE;

2110: --
2111: l_comment_id
2112: pay_personal_payment_methods_f.comment_id%TYPE;
2113: l_effective_start_date
2114: pay_personal_payment_methods_f.effective_start_date%TYPE;
2115: l_effective_end_date
2116: pay_personal_payment_methods_f.effective_end_date%TYPE;
2117: l_category varchar(2000);
2118: l_territory_code varchar2(2000);

Line 2116: pay_personal_payment_methods_f.effective_end_date%TYPE;

2112: pay_personal_payment_methods_f.comment_id%TYPE;
2113: l_effective_start_date
2114: pay_personal_payment_methods_f.effective_start_date%TYPE;
2115: l_effective_end_date
2116: pay_personal_payment_methods_f.effective_end_date%TYPE;
2117: l_category varchar(2000);
2118: l_territory_code varchar2(2000);
2119: l_exa_territory_code varchar2(2000);
2120: --

Line 2124: from pay_personal_payment_methods_f ppm

2120: --
2121: cursor bgsel is
2122: select ppm.business_group_id,
2123: ppm.external_account_id
2124: from pay_personal_payment_methods_f ppm
2125: where ppm.personal_payment_method_id = p_personal_payment_method_id
2126: and p_effective_date between ppm.effective_start_date
2127: and ppm.effective_end_date;
2128: --

Line 2137: from pay_personal_payment_methods_f ppm

2133: where pea.external_account_id = l_external_account_id;
2134: --
2135: cursor csr_chk_pay_type is
2136: select pyt.category
2137: from pay_personal_payment_methods_f ppm
2138: , pay_org_payment_methods_f opm
2139: , pay_payment_types pyt
2140: where ppm.personal_payment_method_id = p_personal_payment_method_id
2141: and p_effective_date between

Line 2154: pay_personal_payment_methods_f ppm

2150: p_effective_date date) is
2151: select decode(ppt.territory_code,null,null,ppt.territory_code||'_')||UPPER(ppt.payment_type_name) ppm_information_category
2152: from pay_payment_types ppt,
2153: pay_org_payment_methods_f opm,
2154: pay_personal_payment_methods_f ppm
2155: where ppm.personal_payment_method_id = p_personal_payment_method_id
2156: and p_effective_date between ppm.effective_start_date and ppm.effective_end_date
2157: and opm.org_payment_method_id = ppm.org_payment_method_id
2158: and p_effective_date between opm.effective_start_date and opm.effective_end_date