DBA Data[Home] [Help]

APPS.PAY_DK_PR_ASG dependencies on FND_DATE

Line 105: ,fnd_date.canonical_to_date(PAY_DK_PR_ASG.GET_PARAMETER(legislative_parameters,'FROM_DATE'))

101: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
102: SELECT PAY_DK_PR_ASG.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')
103: ,PAY_DK_PR_ASG.GET_PARAMETER(legislative_parameters,'ASSIGNMENT_SET_ID')
104: ,PAY_DK_PR_ASG.GET_PARAMETER(legislative_parameters,'ARCHIVE')
105: ,fnd_date.canonical_to_date(PAY_DK_PR_ASG.GET_PARAMETER(legislative_parameters,'FROM_DATE'))
106: ,fnd_date.canonical_to_date(PAY_DK_PR_ASG.GET_PARAMETER(legislative_parameters,'TO_DATE'))
107: ,effective_date
108: ,business_group_id
109: FROM pay_payroll_actions

Line 106: ,fnd_date.canonical_to_date(PAY_DK_PR_ASG.GET_PARAMETER(legislative_parameters,'TO_DATE'))

102: SELECT PAY_DK_PR_ASG.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')
103: ,PAY_DK_PR_ASG.GET_PARAMETER(legislative_parameters,'ASSIGNMENT_SET_ID')
104: ,PAY_DK_PR_ASG.GET_PARAMETER(legislative_parameters,'ARCHIVE')
105: ,fnd_date.canonical_to_date(PAY_DK_PR_ASG.GET_PARAMETER(legislative_parameters,'FROM_DATE'))
106: ,fnd_date.canonical_to_date(PAY_DK_PR_ASG.GET_PARAMETER(legislative_parameters,'TO_DATE'))
107: ,effective_date
108: ,business_group_id
109: FROM pay_payroll_actions
110: WHERE payroll_action_id = p_payroll_action_id;

Line 852: fnd_date.string_to_date(pai2.action_information10,'DD-MON-YYYY');

848: TO_NUMBER (pai2.action_information13),
849: pai2.action_information15,
850: TO_NUMBER (pai2.action_information7),
851: TO_NUMBER (pai2.action_information6),
852: fnd_date.string_to_date(pai2.action_information10,'DD-MON-YYYY');
853:
854: BEGIN
855: IF p_payroll_action_id IS NULL THEN
856: