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 467: from pay_personal_payment_methods_f ppm

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

Line 656: l_external_account_id pay_personal_payment_methods_f.external_account_id%TYPE;

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

Line 662: l_ppm_information_category pay_personal_payment_methods_f.ppm_information_category%TYPE;

658: l_exa_ovn number;
659: l_exists varchar2(1);
660: l_category varchar2(2);
661: l_effective_date date;
662: l_ppm_information_category pay_personal_payment_methods_f.ppm_information_category%TYPE;
663: --
664: -- Declare OUT variables.
665: --
666: l_personal_payment_method_id pay_personal_payment_methods_f.personal_payment_method_id%TYPE;

Line 666: l_personal_payment_method_id pay_personal_payment_methods_f.personal_payment_method_id%TYPE;

662: l_ppm_information_category pay_personal_payment_methods_f.ppm_information_category%TYPE;
663: --
664: -- Declare OUT variables.
665: --
666: l_personal_payment_method_id pay_personal_payment_methods_f.personal_payment_method_id%TYPE;
667: l_object_version_number pay_personal_payment_methods_f.object_version_number%TYPE;
668: l_effective_start_date pay_personal_payment_methods_f.effective_start_date%TYPE;
669: l_effective_end_date pay_personal_payment_methods_f.effective_end_date%TYPE;
670: l_comment_id pay_personal_payment_methods_f.comment_id%TYPE;

Line 667: l_object_version_number pay_personal_payment_methods_f.object_version_number%TYPE;

663: --
664: -- Declare OUT variables.
665: --
666: l_personal_payment_method_id pay_personal_payment_methods_f.personal_payment_method_id%TYPE;
667: l_object_version_number pay_personal_payment_methods_f.object_version_number%TYPE;
668: l_effective_start_date pay_personal_payment_methods_f.effective_start_date%TYPE;
669: l_effective_end_date pay_personal_payment_methods_f.effective_end_date%TYPE;
670: l_comment_id pay_personal_payment_methods_f.comment_id%TYPE;
671: --

Line 668: l_effective_start_date pay_personal_payment_methods_f.effective_start_date%TYPE;

664: -- Declare OUT variables.
665: --
666: l_personal_payment_method_id pay_personal_payment_methods_f.personal_payment_method_id%TYPE;
667: l_object_version_number pay_personal_payment_methods_f.object_version_number%TYPE;
668: l_effective_start_date pay_personal_payment_methods_f.effective_start_date%TYPE;
669: l_effective_end_date pay_personal_payment_methods_f.effective_end_date%TYPE;
670: l_comment_id pay_personal_payment_methods_f.comment_id%TYPE;
671: --
672: cursor bgsel is

Line 669: l_effective_end_date pay_personal_payment_methods_f.effective_end_date%TYPE;

665: --
666: l_personal_payment_method_id pay_personal_payment_methods_f.personal_payment_method_id%TYPE;
667: l_object_version_number pay_personal_payment_methods_f.object_version_number%TYPE;
668: l_effective_start_date pay_personal_payment_methods_f.effective_start_date%TYPE;
669: l_effective_end_date pay_personal_payment_methods_f.effective_end_date%TYPE;
670: l_comment_id pay_personal_payment_methods_f.comment_id%TYPE;
671: --
672: cursor bgsel is
673: select pa.business_group_id

Line 670: l_comment_id pay_personal_payment_methods_f.comment_id%TYPE;

666: l_personal_payment_method_id pay_personal_payment_methods_f.personal_payment_method_id%TYPE;
667: l_object_version_number pay_personal_payment_methods_f.object_version_number%TYPE;
668: l_effective_start_date pay_personal_payment_methods_f.effective_start_date%TYPE;
669: l_effective_end_date pay_personal_payment_methods_f.effective_end_date%TYPE;
670: l_comment_id pay_personal_payment_methods_f.comment_id%TYPE;
671: --
672: cursor bgsel is
673: select pa.business_group_id
674: from per_assignments_f pa

Line 1907: pay_personal_payment_methods_f.external_account_id%TYPE;

1903: l_proc varchar2(72);
1904: l_business_group_id per_assignments_f.business_group_id%TYPE;
1905: l_validate boolean := FALSE;
1906: l_external_account_id
1907: pay_personal_payment_methods_f.external_account_id%TYPE;
1908: l_object_version_number
1909: pay_external_accounts.object_version_number%TYPE;
1910: l_exa_ovn number;
1911: l_effective_date date;

Line 1912: l_ppm_information_category pay_personal_payment_methods_f.ppm_information_category%TYPE;

1908: l_object_version_number
1909: pay_external_accounts.object_version_number%TYPE;
1910: l_exa_ovn number;
1911: l_effective_date date;
1912: l_ppm_information_category pay_personal_payment_methods_f.ppm_information_category%TYPE;
1913: --
1914: -- Declare OUT variables
1915: --
1916: l_comment_id

Line 1917: pay_personal_payment_methods_f.comment_id%TYPE;

1913: --
1914: -- Declare OUT variables
1915: --
1916: l_comment_id
1917: pay_personal_payment_methods_f.comment_id%TYPE;
1918: l_effective_start_date
1919: pay_personal_payment_methods_f.effective_start_date%TYPE;
1920: l_effective_end_date
1921: pay_personal_payment_methods_f.effective_end_date%TYPE;

Line 1919: pay_personal_payment_methods_f.effective_start_date%TYPE;

1915: --
1916: l_comment_id
1917: pay_personal_payment_methods_f.comment_id%TYPE;
1918: l_effective_start_date
1919: pay_personal_payment_methods_f.effective_start_date%TYPE;
1920: l_effective_end_date
1921: pay_personal_payment_methods_f.effective_end_date%TYPE;
1922: l_category varchar(2000);
1923: l_territory_code varchar2(2000);

Line 1921: pay_personal_payment_methods_f.effective_end_date%TYPE;

1917: pay_personal_payment_methods_f.comment_id%TYPE;
1918: l_effective_start_date
1919: pay_personal_payment_methods_f.effective_start_date%TYPE;
1920: l_effective_end_date
1921: pay_personal_payment_methods_f.effective_end_date%TYPE;
1922: l_category varchar(2000);
1923: l_territory_code varchar2(2000);
1924: l_exa_territory_code varchar2(2000);
1925: --

Line 1929: from pay_personal_payment_methods_f ppm

1925: --
1926: cursor bgsel is
1927: select ppm.business_group_id,
1928: ppm.external_account_id
1929: from pay_personal_payment_methods_f ppm
1930: where ppm.personal_payment_method_id = p_personal_payment_method_id
1931: and p_effective_date between ppm.effective_start_date
1932: and ppm.effective_end_date;
1933: --

Line 1942: from pay_personal_payment_methods_f ppm

1938: where pea.external_account_id = l_external_account_id;
1939: --
1940: cursor csr_chk_pay_type is
1941: select pyt.category
1942: from pay_personal_payment_methods_f ppm
1943: , pay_org_payment_methods_f opm
1944: , pay_payment_types pyt
1945: where ppm.personal_payment_method_id = p_personal_payment_method_id
1946: and p_effective_date between

Line 1959: pay_personal_payment_methods_f ppm

1955: p_effective_date date) is
1956: select decode(ppt.territory_code,null,null,ppt.territory_code||'_')||UPPER(ppt.payment_type_name) ppm_information_category
1957: from pay_payment_types ppt,
1958: pay_org_payment_methods_f opm,
1959: pay_personal_payment_methods_f ppm
1960: where ppm.personal_payment_method_id = p_personal_payment_method_id
1961: and p_effective_date between ppm.effective_start_date and ppm.effective_end_date
1962: and opm.org_payment_method_id = ppm.org_payment_method_id
1963: and p_effective_date between opm.effective_start_date and opm.effective_end_date