DBA Data[Home] [Help]

APPS.PAY_DK_PR_ORG dependencies on FND_DATE

Line 77: fnd_date.canonical_to_date(PAY_DK_PR_ORG.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_ORG.GET_PARAMETER(legislative_parameters,'FROM_DATE'))
78: ,fnd_date.canonical_to_date(PAY_DK_PR_ORG.GET_PARAMETER(legislative_parameters,'TO_DATE'))
79: ,PAY_DK_PR_ORG.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')
80: ,PAY_DK_PR_ORG.GET_PARAMETER(legislative_parameters,'ORGANIZATION_ID')
81: ,PAY_DK_PR_ORG.GET_PARAMETER(legislative_parameters,'ELEMENT_SET_ID')

Line 78: ,fnd_date.canonical_to_date(PAY_DK_PR_ORG.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_ORG.GET_PARAMETER(legislative_parameters,'FROM_DATE'))
78: ,fnd_date.canonical_to_date(PAY_DK_PR_ORG.GET_PARAMETER(legislative_parameters,'TO_DATE'))
79: ,PAY_DK_PR_ORG.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')
80: ,PAY_DK_PR_ORG.GET_PARAMETER(legislative_parameters,'ORGANIZATION_ID')
81: ,PAY_DK_PR_ORG.GET_PARAMETER(legislative_parameters,'ELEMENT_SET_ID')
82: ,PAY_DK_PR_ORG.GET_PARAMETER(legislative_parameters,'ARCHIVE')

Line 760: ,fnd_date.string_to_date(pai2.action_information9,'DD-MON-YYYY');

756: TO_NUMBER(pai2.action_information2)
757: ,TO_NUMBER(pai2.action_information4)
758: ,TO_NUMBER(pai2.action_information7)
759: ,TO_NUMBER(pai2.action_information6)
760: ,fnd_date.string_to_date(pai2.action_information9,'DD-MON-YYYY');
761:
762: BEGIN
763: IF p_payroll_action_id IS NULL THEN
764: BEGIN