DBA Data[Home] [Help]

APPS.PAY_SE_SLSR dependencies on FND_DATE

Line 23: fnd_date.canonical_to_date (action_information10) start_date,

19: daily_hours,
20: fnd_number.canonical_to_number (action_information8) days_per_year,
21: fnd_number.canonical_to_number (action_information9)
22: hours_per_year,
23: fnd_date.canonical_to_date (action_information10) start_date,
24: fnd_date.canonical_to_date (action_information11)
25: end_date
26: FROM pay_action_information
27: WHERE action_context_type = 'PA'

Line 24: fnd_date.canonical_to_date (action_information11)

20: fnd_number.canonical_to_number (action_information8) days_per_year,
21: fnd_number.canonical_to_number (action_information9)
22: hours_per_year,
23: fnd_date.canonical_to_date (action_information10) start_date,
24: fnd_date.canonical_to_date (action_information11)
25: end_date
26: FROM pay_action_information
27: WHERE action_context_type = 'PA'
28: AND action_context_id = csr_v_pa_id

Line 47: fnd_date.canonical_to_date (action_information10) start_date,

43: daily_hours,
44: fnd_number.canonical_to_number (action_information8) days_per_year,
45: fnd_number.canonical_to_number (action_information9)
46: hours_per_year,
47: fnd_date.canonical_to_date (action_information10) start_date,
48: fnd_date.canonical_to_date (action_information11)
49: end_date
50: FROM pay_action_information
51: WHERE action_context_type = 'PA'

Line 48: fnd_date.canonical_to_date (action_information11)

44: fnd_number.canonical_to_number (action_information8) days_per_year,
45: fnd_number.canonical_to_number (action_information9)
46: hours_per_year,
47: fnd_date.canonical_to_date (action_information10) start_date,
48: fnd_date.canonical_to_date (action_information11)
49: end_date
50: FROM pay_action_information
51: WHERE action_context_type = 'PA'
52: AND action_context_id = csr_v_pa_id