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_DK_PR_ELE dependencies on PAY_DK_PR_ELE

Line 1: PACKAGE BODY PAY_DK_PR_ELE AS

1: PACKAGE BODY PAY_DK_PR_ELE AS
2: /* $Header: pydkprele.pkb 120.15 2012/01/19 09:07:13 rpahune ship $ */
3:
4: g_debug boolean := hr_utility.debug_enabled;
5: l_business_group_id NUMBER;

Line 77: fnd_date.canonical_to_date(PAY_DK_PR_ELE.GET_PARAMETER(legislative_parameters,'FROM_DATE'))

73:
74:
75: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
76: SELECT
77: fnd_date.canonical_to_date(PAY_DK_PR_ELE.GET_PARAMETER(legislative_parameters,'FROM_DATE'))
78: ,fnd_date.canonical_to_date(PAY_DK_PR_ELE.GET_PARAMETER(legislative_parameters,'TO_DATE'))
79: ,PAY_DK_PR_ELE.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')
80: ,PAY_DK_PR_ELE.GET_PARAMETER(legislative_parameters,'ELEMENT_SET_ID')
81: ,PAY_DK_PR_ELE.GET_PARAMETER(legislative_parameters,'ARCHIVE')

Line 78: ,fnd_date.canonical_to_date(PAY_DK_PR_ELE.GET_PARAMETER(legislative_parameters,'TO_DATE'))

74:
75: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
76: SELECT
77: fnd_date.canonical_to_date(PAY_DK_PR_ELE.GET_PARAMETER(legislative_parameters,'FROM_DATE'))
78: ,fnd_date.canonical_to_date(PAY_DK_PR_ELE.GET_PARAMETER(legislative_parameters,'TO_DATE'))
79: ,PAY_DK_PR_ELE.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')
80: ,PAY_DK_PR_ELE.GET_PARAMETER(legislative_parameters,'ELEMENT_SET_ID')
81: ,PAY_DK_PR_ELE.GET_PARAMETER(legislative_parameters,'ARCHIVE')
82: ,effective_date

Line 79: ,PAY_DK_PR_ELE.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')

75: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
76: SELECT
77: fnd_date.canonical_to_date(PAY_DK_PR_ELE.GET_PARAMETER(legislative_parameters,'FROM_DATE'))
78: ,fnd_date.canonical_to_date(PAY_DK_PR_ELE.GET_PARAMETER(legislative_parameters,'TO_DATE'))
79: ,PAY_DK_PR_ELE.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')
80: ,PAY_DK_PR_ELE.GET_PARAMETER(legislative_parameters,'ELEMENT_SET_ID')
81: ,PAY_DK_PR_ELE.GET_PARAMETER(legislative_parameters,'ARCHIVE')
82: ,effective_date
83: ,business_group_id

Line 80: ,PAY_DK_PR_ELE.GET_PARAMETER(legislative_parameters,'ELEMENT_SET_ID')

76: SELECT
77: fnd_date.canonical_to_date(PAY_DK_PR_ELE.GET_PARAMETER(legislative_parameters,'FROM_DATE'))
78: ,fnd_date.canonical_to_date(PAY_DK_PR_ELE.GET_PARAMETER(legislative_parameters,'TO_DATE'))
79: ,PAY_DK_PR_ELE.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')
80: ,PAY_DK_PR_ELE.GET_PARAMETER(legislative_parameters,'ELEMENT_SET_ID')
81: ,PAY_DK_PR_ELE.GET_PARAMETER(legislative_parameters,'ARCHIVE')
82: ,effective_date
83: ,business_group_id
84: FROM

Line 81: ,PAY_DK_PR_ELE.GET_PARAMETER(legislative_parameters,'ARCHIVE')

77: fnd_date.canonical_to_date(PAY_DK_PR_ELE.GET_PARAMETER(legislative_parameters,'FROM_DATE'))
78: ,fnd_date.canonical_to_date(PAY_DK_PR_ELE.GET_PARAMETER(legislative_parameters,'TO_DATE'))
79: ,PAY_DK_PR_ELE.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')
80: ,PAY_DK_PR_ELE.GET_PARAMETER(legislative_parameters,'ELEMENT_SET_ID')
81: ,PAY_DK_PR_ELE.GET_PARAMETER(legislative_parameters,'ARCHIVE')
82: ,effective_date
83: ,business_group_id
84: FROM
85: pay_payroll_actions

Line 200: SUM (pay_balance_pkg.get_value(pay_dk_pr_ele.get_defined_balance_id

196: ,p_from_date DATE
197: ,p_to_date DATE)
198: IS
199: SELECT
200: SUM (pay_balance_pkg.get_value(pay_dk_pr_ele.get_defined_balance_id
201: (pivf.input_value_id,'_ASG_RUN')
202: ,paa1.assignment_action_id)) ele_ytd
203: FROM
204: per_all_assignments_f paaf

Line 272: ,pay_dk_pr_ele.costed_code(prr.run_result_id,pivf.input_value_id) costed_code

268: ,ppf.payroll_id payroll_id
269: ,petf.element_type_id ele_type_id
270: ,petf.processing_priority ele_proc_prior
271: ,NVL(petf.reporting_name,petf.element_name) ele_name
272: ,pay_dk_pr_ele.costed_code(prr.run_result_id,pivf.input_value_id) costed_code
273: ,pivf.input_value_id input_value_id
274: ,to_char(ppa1.date_earned,'DD-MON-RRRR') date_earned
275: ,pay_balance_pkg.get_value(pay_dk_pr_ele.get_defined_balance_id
276: (pivf.input_value_id,'_ASG_RUN')

Line 275: ,pay_balance_pkg.get_value(pay_dk_pr_ele.get_defined_balance_id

271: ,NVL(petf.reporting_name,petf.element_name) ele_name
272: ,pay_dk_pr_ele.costed_code(prr.run_result_id,pivf.input_value_id) costed_code
273: ,pivf.input_value_id input_value_id
274: ,to_char(ppa1.date_earned,'DD-MON-RRRR') date_earned
275: ,pay_balance_pkg.get_value(pay_dk_pr_ele.get_defined_balance_id
276: (pivf.input_value_id,'_ASG_RUN')
277: ,paa1.assignment_action_id) pay_value
278: /* ,pay_balance_pkg.get_value(pay_dk_pr_ele.get_defined_balance_id
279: (pivf.input_value_id,'_ASG_YTD'),

Line 278: /* ,pay_balance_pkg.get_value(pay_dk_pr_ele.get_defined_balance_id

274: ,to_char(ppa1.date_earned,'DD-MON-RRRR') date_earned
275: ,pay_balance_pkg.get_value(pay_dk_pr_ele.get_defined_balance_id
276: (pivf.input_value_id,'_ASG_RUN')
277: ,paa1.assignment_action_id) pay_value
278: /* ,pay_balance_pkg.get_value(pay_dk_pr_ele.get_defined_balance_id
279: (pivf.input_value_id,'_ASG_YTD'),
280: paa1.assignment_action_id) balance_amount*/
281: FROM
282: per_all_assignments_f paaf

Line 362: ,pay_dk_pr_ele.costed_code(prr.run_result_id,pivf.input_value_id) costed_code

358: ,ppf.payroll_id payroll_id
359: ,petf.element_type_id ele_type_id
360: ,petf.processing_priority ele_proc_prior
361: ,NVL(petf.reporting_name,petf.element_name) ele_name
362: ,pay_dk_pr_ele.costed_code(prr.run_result_id,pivf.input_value_id) costed_code
363: ,pivf.input_value_id input_value_id
364: ,to_char(ppa1.date_earned,'DD-MON-RRRR') date_earned
365: ,pay_balance_pkg.get_value(pay_dk_pr_ele.get_defined_balance_id
366: (pivf.input_value_id,'_ASG_RUN')

Line 365: ,pay_balance_pkg.get_value(pay_dk_pr_ele.get_defined_balance_id

361: ,NVL(petf.reporting_name,petf.element_name) ele_name
362: ,pay_dk_pr_ele.costed_code(prr.run_result_id,pivf.input_value_id) costed_code
363: ,pivf.input_value_id input_value_id
364: ,to_char(ppa1.date_earned,'DD-MON-RRRR') date_earned
365: ,pay_balance_pkg.get_value(pay_dk_pr_ele.get_defined_balance_id
366: (pivf.input_value_id,'_ASG_RUN')
367: ,paa1.assignment_action_id) pay_value
368: /* ,pay_balance_pkg.get_value(pay_dk_pr_ele.get_defined_balance_id
369: (pivf.input_value_id,'_ASG_YTD'),

Line 368: /* ,pay_balance_pkg.get_value(pay_dk_pr_ele.get_defined_balance_id

364: ,to_char(ppa1.date_earned,'DD-MON-RRRR') date_earned
365: ,pay_balance_pkg.get_value(pay_dk_pr_ele.get_defined_balance_id
366: (pivf.input_value_id,'_ASG_RUN')
367: ,paa1.assignment_action_id) pay_value
368: /* ,pay_balance_pkg.get_value(pay_dk_pr_ele.get_defined_balance_id
369: (pivf.input_value_id,'_ASG_YTD'),
370: paa1.assignment_action_id) balance_amount*/
371: FROM
372:

Line 459: PAY_DK_PR_ELE.GET_ALL_PARAMETERS(

455: AND ppa.business_group_id = ppf.business_group_id
456: ORDER BY ppf.person_id';
457:
458: -- fetch the input parameter values
459: PAY_DK_PR_ELE.GET_ALL_PARAMETERS(
460: pactid
461: ,l_business_group_id
462: ,l_effective_date
463: ,l_archive

Line 834: END PAY_DK_PR_ELE;

830: p_xml:=p_xml||'';
831: END IF;
832:
833: END POPULATE_DETAILS;
834: END PAY_DK_PR_ELE;