DBA Data[Home] [Help]

APPS.PAY_DK_PR_ELE dependencies on FND_DATE

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 728: ,fnd_date.string_to_date(pai2.action_information7,'DD-MON-RRRR');

724: ORDER BY
725: TO_NUMBER(pai2.action_information2)
726: ,TO_NUMBER(pai2.action_information5)
727: ,TO_NUMBER(pai2.action_information4)
728: ,fnd_date.string_to_date(pai2.action_information7,'DD-MON-RRRR');
729:
730: BEGIN
731: IF p_payroll_action_id IS NULL THEN
732: BEGIN