APPS.PAY_SE_SLSR dependencies on FND_NUMBER

Line 17: org_number, fnd_number.canonical_to_number (action_information6) week_hours,

13: p_leagal_employer_id VARCHAR2
14: ) IS
15: SELECT action_information3 legal_employer_id, action_information4 legal_employer_name,
16: action_information5
17: org_number, fnd_number.canonical_to_number (action_information6) week_hours,
18: fnd_number.canonical_to_number (action_information7)
19: daily_hours,
20: fnd_number.canonical_to_number (action_information8) days_per_year,
21: fnd_number.canonical_to_number (action_information9)

Line 18: fnd_number.canonical_to_number (action_information7)

14: ) IS
15: SELECT action_information3 legal_employer_id, action_information4 legal_employer_name,
16: action_information5
17: org_number, fnd_number.canonical_to_number (action_information6) week_hours,
18: fnd_number.canonical_to_number (action_information7)
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,

Line 20: fnd_number.canonical_to_number (action_information8) days_per_year,

16: action_information5
17: org_number, fnd_number.canonical_to_number (action_information6) week_hours,
18: fnd_number.canonical_to_number (action_information7)
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)

Line 21: fnd_number.canonical_to_number (action_information9)

17: org_number, fnd_number.canonical_to_number (action_information6) week_hours,
18: fnd_number.canonical_to_number (action_information7)
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

Line 41: org_number, fnd_number.canonical_to_number (action_information6) week_hours,

37: p_leagal_employer_id VARCHAR2
38: ) IS
39: SELECT action_information3 legal_employer_id, action_information4 legal_employer_name,
40: action_information5
41: org_number, fnd_number.canonical_to_number (action_information6) week_hours,
42: fnd_number.canonical_to_number (action_information7)
43: daily_hours,
44: fnd_number.canonical_to_number (action_information8) days_per_year,
45: fnd_number.canonical_to_number (action_information9)

Line 42: fnd_number.canonical_to_number (action_information7)

38: ) IS
39: SELECT action_information3 legal_employer_id, action_information4 legal_employer_name,
40: action_information5
41: org_number, fnd_number.canonical_to_number (action_information6) week_hours,
42: fnd_number.canonical_to_number (action_information7)
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,

Line 44: fnd_number.canonical_to_number (action_information8) days_per_year,

40: action_information5
41: org_number, fnd_number.canonical_to_number (action_information6) week_hours,
42: fnd_number.canonical_to_number (action_information7)
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)

Line 45: fnd_number.canonical_to_number (action_information9)

41: org_number, fnd_number.canonical_to_number (action_information6) week_hours,
42: fnd_number.canonical_to_number (action_information7)
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

Line 65: SELECT fnd_number.canonical_to_number (action_information6) men_lower_age_count,

61: csr_v_pa_id pay_action_information.action_context_id%TYPE,
62: p_curr_prev_data VARCHAR2,
63: p_leagal_employer_id VARCHAR2
64: ) IS
65: SELECT fnd_number.canonical_to_number (action_information6) men_lower_age_count,
66: fnd_number.canonical_to_number (action_information7)
67: men_middle_age_count,
68: fnd_number.canonical_to_number (action_information8) men_upper_age_count,
69: fnd_number.canonical_to_number (action_information9)

Line 66: fnd_number.canonical_to_number (action_information7)

62: p_curr_prev_data VARCHAR2,
63: p_leagal_employer_id VARCHAR2
64: ) IS
65: SELECT fnd_number.canonical_to_number (action_information6) men_lower_age_count,
66: fnd_number.canonical_to_number (action_information7)
67: men_middle_age_count,
68: fnd_number.canonical_to_number (action_information8) men_upper_age_count,
69: fnd_number.canonical_to_number (action_information9)
70: women_lower_age_count,

Line 68: fnd_number.canonical_to_number (action_information8) men_upper_age_count,

64: ) IS
65: SELECT fnd_number.canonical_to_number (action_information6) men_lower_age_count,
66: fnd_number.canonical_to_number (action_information7)
67: men_middle_age_count,
68: fnd_number.canonical_to_number (action_information8) men_upper_age_count,
69: fnd_number.canonical_to_number (action_information9)
70: women_lower_age_count,
71: fnd_number.canonical_to_number (action_information10) women_middle_age_count,
72: fnd_number.canonical_to_number (action_information11)

Line 69: fnd_number.canonical_to_number (action_information9)

65: SELECT fnd_number.canonical_to_number (action_information6) men_lower_age_count,
66: fnd_number.canonical_to_number (action_information7)
67: men_middle_age_count,
68: fnd_number.canonical_to_number (action_information8) men_upper_age_count,
69: fnd_number.canonical_to_number (action_information9)
70: women_lower_age_count,
71: fnd_number.canonical_to_number (action_information10) women_middle_age_count,
72: fnd_number.canonical_to_number (action_information11)
73: women_upper_age_count,

Line 71: fnd_number.canonical_to_number (action_information10) women_middle_age_count,

67: men_middle_age_count,
68: fnd_number.canonical_to_number (action_information8) men_upper_age_count,
69: fnd_number.canonical_to_number (action_information9)
70: women_lower_age_count,
71: fnd_number.canonical_to_number (action_information10) women_middle_age_count,
72: fnd_number.canonical_to_number (action_information11)
73: women_upper_age_count,
74: fnd_number.canonical_to_number (action_information12) men_lower_age_work_hour,
75: fnd_number.canonical_to_number (action_information13)

Line 72: fnd_number.canonical_to_number (action_information11)

68: fnd_number.canonical_to_number (action_information8) men_upper_age_count,
69: fnd_number.canonical_to_number (action_information9)
70: women_lower_age_count,
71: fnd_number.canonical_to_number (action_information10) women_middle_age_count,
72: fnd_number.canonical_to_number (action_information11)
73: women_upper_age_count,
74: fnd_number.canonical_to_number (action_information12) men_lower_age_work_hour,
75: fnd_number.canonical_to_number (action_information13)
76: men_middle_age_work_hour,

Line 74: fnd_number.canonical_to_number (action_information12) men_lower_age_work_hour,

70: women_lower_age_count,
71: fnd_number.canonical_to_number (action_information10) women_middle_age_count,
72: fnd_number.canonical_to_number (action_information11)
73: women_upper_age_count,
74: fnd_number.canonical_to_number (action_information12) men_lower_age_work_hour,
75: fnd_number.canonical_to_number (action_information13)
76: men_middle_age_work_hour,
77: fnd_number.canonical_to_number (action_information14) men_upper_age_work_hour,
78: fnd_number.canonical_to_number (action_information15)

Line 75: fnd_number.canonical_to_number (action_information13)

71: fnd_number.canonical_to_number (action_information10) women_middle_age_count,
72: fnd_number.canonical_to_number (action_information11)
73: women_upper_age_count,
74: fnd_number.canonical_to_number (action_information12) men_lower_age_work_hour,
75: fnd_number.canonical_to_number (action_information13)
76: men_middle_age_work_hour,
77: fnd_number.canonical_to_number (action_information14) men_upper_age_work_hour,
78: fnd_number.canonical_to_number (action_information15)
79: women_lower_age_work_hour,

Line 77: fnd_number.canonical_to_number (action_information14) men_upper_age_work_hour,

73: women_upper_age_count,
74: fnd_number.canonical_to_number (action_information12) men_lower_age_work_hour,
75: fnd_number.canonical_to_number (action_information13)
76: men_middle_age_work_hour,
77: fnd_number.canonical_to_number (action_information14) men_upper_age_work_hour,
78: fnd_number.canonical_to_number (action_information15)
79: women_lower_age_work_hour,
80: fnd_number.canonical_to_number (action_information16)
81: women_middle_age_work_hour,

Line 78: fnd_number.canonical_to_number (action_information15)

74: fnd_number.canonical_to_number (action_information12) men_lower_age_work_hour,
75: fnd_number.canonical_to_number (action_information13)
76: men_middle_age_work_hour,
77: fnd_number.canonical_to_number (action_information14) men_upper_age_work_hour,
78: fnd_number.canonical_to_number (action_information15)
79: women_lower_age_work_hour,
80: fnd_number.canonical_to_number (action_information16)
81: women_middle_age_work_hour,
82: fnd_number.canonical_to_number (action_information17)

Line 80: fnd_number.canonical_to_number (action_information16)

76: men_middle_age_work_hour,
77: fnd_number.canonical_to_number (action_information14) men_upper_age_work_hour,
78: fnd_number.canonical_to_number (action_information15)
79: women_lower_age_work_hour,
80: fnd_number.canonical_to_number (action_information16)
81: women_middle_age_work_hour,
82: fnd_number.canonical_to_number (action_information17)
83: women_upper_age_work_hour,
84: fnd_number.canonical_to_number (action_information18) men_l_age_sick_leaves,

Line 82: fnd_number.canonical_to_number (action_information17)

78: fnd_number.canonical_to_number (action_information15)
79: women_lower_age_work_hour,
80: fnd_number.canonical_to_number (action_information16)
81: women_middle_age_work_hour,
82: fnd_number.canonical_to_number (action_information17)
83: women_upper_age_work_hour,
84: fnd_number.canonical_to_number (action_information18) men_l_age_sick_leaves,
85: fnd_number.canonical_to_number (action_information19)
86: men_m_age_sick_leaves,

Line 84: fnd_number.canonical_to_number (action_information18) men_l_age_sick_leaves,

80: fnd_number.canonical_to_number (action_information16)
81: women_middle_age_work_hour,
82: fnd_number.canonical_to_number (action_information17)
83: women_upper_age_work_hour,
84: fnd_number.canonical_to_number (action_information18) men_l_age_sick_leaves,
85: fnd_number.canonical_to_number (action_information19)
86: men_m_age_sick_leaves,
87: fnd_number.canonical_to_number (action_information20) men_u_age_sick_leaves,
88: fnd_number.canonical_to_number (action_information21)

Line 85: fnd_number.canonical_to_number (action_information19)

81: women_middle_age_work_hour,
82: fnd_number.canonical_to_number (action_information17)
83: women_upper_age_work_hour,
84: fnd_number.canonical_to_number (action_information18) men_l_age_sick_leaves,
85: fnd_number.canonical_to_number (action_information19)
86: men_m_age_sick_leaves,
87: fnd_number.canonical_to_number (action_information20) men_u_age_sick_leaves,
88: fnd_number.canonical_to_number (action_information21)
89: women_l_age_sick_leaves,

Line 87: fnd_number.canonical_to_number (action_information20) men_u_age_sick_leaves,

83: women_upper_age_work_hour,
84: fnd_number.canonical_to_number (action_information18) men_l_age_sick_leaves,
85: fnd_number.canonical_to_number (action_information19)
86: men_m_age_sick_leaves,
87: fnd_number.canonical_to_number (action_information20) men_u_age_sick_leaves,
88: fnd_number.canonical_to_number (action_information21)
89: women_l_age_sick_leaves,
90: fnd_number.canonical_to_number (action_information22) women_m_age_sick_leaves,
91: fnd_number.canonical_to_number (action_information23)

Line 88: fnd_number.canonical_to_number (action_information21)

84: fnd_number.canonical_to_number (action_information18) men_l_age_sick_leaves,
85: fnd_number.canonical_to_number (action_information19)
86: men_m_age_sick_leaves,
87: fnd_number.canonical_to_number (action_information20) men_u_age_sick_leaves,
88: fnd_number.canonical_to_number (action_information21)
89: women_l_age_sick_leaves,
90: fnd_number.canonical_to_number (action_information22) women_m_age_sick_leaves,
91: fnd_number.canonical_to_number (action_information23)
92: women_u_age_sick_leaves,

Line 90: fnd_number.canonical_to_number (action_information22) women_m_age_sick_leaves,

86: men_m_age_sick_leaves,
87: fnd_number.canonical_to_number (action_information20) men_u_age_sick_leaves,
88: fnd_number.canonical_to_number (action_information21)
89: women_l_age_sick_leaves,
90: fnd_number.canonical_to_number (action_information22) women_m_age_sick_leaves,
91: fnd_number.canonical_to_number (action_information23)
92: women_u_age_sick_leaves,
93: fnd_number.canonical_to_number (action_information24) men_l_age_l_sick_leaves,
94: fnd_number.canonical_to_number (action_information25)

Line 91: fnd_number.canonical_to_number (action_information23)

87: fnd_number.canonical_to_number (action_information20) men_u_age_sick_leaves,
88: fnd_number.canonical_to_number (action_information21)
89: women_l_age_sick_leaves,
90: fnd_number.canonical_to_number (action_information22) women_m_age_sick_leaves,
91: fnd_number.canonical_to_number (action_information23)
92: women_u_age_sick_leaves,
93: fnd_number.canonical_to_number (action_information24) men_l_age_l_sick_leaves,
94: fnd_number.canonical_to_number (action_information25)
95: men_m_age_l_sick_leaves,

Line 93: fnd_number.canonical_to_number (action_information24) men_l_age_l_sick_leaves,

89: women_l_age_sick_leaves,
90: fnd_number.canonical_to_number (action_information22) women_m_age_sick_leaves,
91: fnd_number.canonical_to_number (action_information23)
92: women_u_age_sick_leaves,
93: fnd_number.canonical_to_number (action_information24) men_l_age_l_sick_leaves,
94: fnd_number.canonical_to_number (action_information25)
95: men_m_age_l_sick_leaves,
96: fnd_number.canonical_to_number (action_information26) men_u_age_l_sick_leaves,
97: fnd_number.canonical_to_number (action_information27)

Line 94: fnd_number.canonical_to_number (action_information25)

90: fnd_number.canonical_to_number (action_information22) women_m_age_sick_leaves,
91: fnd_number.canonical_to_number (action_information23)
92: women_u_age_sick_leaves,
93: fnd_number.canonical_to_number (action_information24) men_l_age_l_sick_leaves,
94: fnd_number.canonical_to_number (action_information25)
95: men_m_age_l_sick_leaves,
96: fnd_number.canonical_to_number (action_information26) men_u_age_l_sick_leaves,
97: fnd_number.canonical_to_number (action_information27)
98: women_l_age_l_sick_leaves,

Line 96: fnd_number.canonical_to_number (action_information26) men_u_age_l_sick_leaves,

92: women_u_age_sick_leaves,
93: fnd_number.canonical_to_number (action_information24) men_l_age_l_sick_leaves,
94: fnd_number.canonical_to_number (action_information25)
95: men_m_age_l_sick_leaves,
96: fnd_number.canonical_to_number (action_information26) men_u_age_l_sick_leaves,
97: fnd_number.canonical_to_number (action_information27)
98: women_l_age_l_sick_leaves,
99: fnd_number.canonical_to_number (action_information28)
100: women_m_age_l_sick_leaves,

Line 97: fnd_number.canonical_to_number (action_information27)

93: fnd_number.canonical_to_number (action_information24) men_l_age_l_sick_leaves,
94: fnd_number.canonical_to_number (action_information25)
95: men_m_age_l_sick_leaves,
96: fnd_number.canonical_to_number (action_information26) men_u_age_l_sick_leaves,
97: fnd_number.canonical_to_number (action_information27)
98: women_l_age_l_sick_leaves,
99: fnd_number.canonical_to_number (action_information28)
100: women_m_age_l_sick_leaves,
101: fnd_number.canonical_to_number (action_information29)

Line 99: fnd_number.canonical_to_number (action_information28)

95: men_m_age_l_sick_leaves,
96: fnd_number.canonical_to_number (action_information26) men_u_age_l_sick_leaves,
97: fnd_number.canonical_to_number (action_information27)
98: women_l_age_l_sick_leaves,
99: fnd_number.canonical_to_number (action_information28)
100: women_m_age_l_sick_leaves,
101: fnd_number.canonical_to_number (action_information29)
102: women_u_age_l_sick_leaves
103: FROM pay_action_information

Line 101: fnd_number.canonical_to_number (action_information29)

97: fnd_number.canonical_to_number (action_information27)
98: women_l_age_l_sick_leaves,
99: fnd_number.canonical_to_number (action_information28)
100: women_m_age_l_sick_leaves,
101: fnd_number.canonical_to_number (action_information29)
102: women_u_age_l_sick_leaves
103: FROM pay_action_information
104: WHERE action_context_type = 'PA'
105: AND action_context_id = csr_v_pa_id

Line 120: SELECT fnd_number.canonical_to_number (action_information6) leave_to_work_hours,

116: csr_v_pa_id pay_action_information.action_context_id%TYPE,
117: p_curr_prev_stat VARCHAR2,
118: p_leagal_employer_id VARCHAR2
119: ) IS
120: SELECT fnd_number.canonical_to_number (action_information6) leave_to_work_hours,
121: fnd_number.canonical_to_number (action_information7)
122: long_leave_part,
123: fnd_number.canonical_to_number (action_information8) men_leave_to_work_hour,
124: fnd_number.canonical_to_number (action_information9)

Line 121: fnd_number.canonical_to_number (action_information7)

117: p_curr_prev_stat VARCHAR2,
118: p_leagal_employer_id VARCHAR2
119: ) IS
120: SELECT fnd_number.canonical_to_number (action_information6) leave_to_work_hours,
121: fnd_number.canonical_to_number (action_information7)
122: long_leave_part,
123: fnd_number.canonical_to_number (action_information8) men_leave_to_work_hour,
124: fnd_number.canonical_to_number (action_information9)
125: women_leave_to_work_hour,

Line 123: fnd_number.canonical_to_number (action_information8) men_leave_to_work_hour,

119: ) IS
120: SELECT fnd_number.canonical_to_number (action_information6) leave_to_work_hours,
121: fnd_number.canonical_to_number (action_information7)
122: long_leave_part,
123: fnd_number.canonical_to_number (action_information8) men_leave_to_work_hour,
124: fnd_number.canonical_to_number (action_information9)
125: women_leave_to_work_hour,
126: fnd_number.canonical_to_number (action_information10) leave_to_work_hour_lower,
127: fnd_number.canonical_to_number (action_information11)

Line 124: fnd_number.canonical_to_number (action_information9)

120: SELECT fnd_number.canonical_to_number (action_information6) leave_to_work_hours,
121: fnd_number.canonical_to_number (action_information7)
122: long_leave_part,
123: fnd_number.canonical_to_number (action_information8) men_leave_to_work_hour,
124: fnd_number.canonical_to_number (action_information9)
125: women_leave_to_work_hour,
126: fnd_number.canonical_to_number (action_information10) leave_to_work_hour_lower,
127: fnd_number.canonical_to_number (action_information11)
128: leave_to_work_hour_middle,

Line 126: fnd_number.canonical_to_number (action_information10) leave_to_work_hour_lower,

122: long_leave_part,
123: fnd_number.canonical_to_number (action_information8) men_leave_to_work_hour,
124: fnd_number.canonical_to_number (action_information9)
125: women_leave_to_work_hour,
126: fnd_number.canonical_to_number (action_information10) leave_to_work_hour_lower,
127: fnd_number.canonical_to_number (action_information11)
128: leave_to_work_hour_middle,
129: fnd_number.canonical_to_number (action_information12) leave_to_work_hour_upper
130: FROM pay_action_information

Line 127: fnd_number.canonical_to_number (action_information11)

123: fnd_number.canonical_to_number (action_information8) men_leave_to_work_hour,
124: fnd_number.canonical_to_number (action_information9)
125: women_leave_to_work_hour,
126: fnd_number.canonical_to_number (action_information10) leave_to_work_hour_lower,
127: fnd_number.canonical_to_number (action_information11)
128: leave_to_work_hour_middle,
129: fnd_number.canonical_to_number (action_information12) leave_to_work_hour_upper
130: FROM pay_action_information
131: WHERE action_context_type = 'PA'

Line 129: fnd_number.canonical_to_number (action_information12) leave_to_work_hour_upper

125: women_leave_to_work_hour,
126: fnd_number.canonical_to_number (action_information10) leave_to_work_hour_lower,
127: fnd_number.canonical_to_number (action_information11)
128: leave_to_work_hour_middle,
129: fnd_number.canonical_to_number (action_information12) leave_to_work_hour_upper
130: FROM pay_action_information
131: WHERE action_context_type = 'PA'
132: AND action_context_id = csr_v_pa_id
133: AND action_information_category = 'EMEA REPORT INFORMATION'

Line 142: SELECT fnd_number.canonical_to_number (action_information6) leave_to_work_hours,

138: csr_v_pa_id pay_action_information.action_context_id%TYPE,
139: p_curr_prev_stat VARCHAR2,
140: p_leagal_employer_id VARCHAR2
141: ) IS
142: SELECT fnd_number.canonical_to_number (action_information6) leave_to_work_hours,
143: fnd_number.canonical_to_number (action_information7)
144: long_leave_part,
145: fnd_number.canonical_to_number (action_information8) men_leave_to_work_hour,
146: fnd_number.canonical_to_number (action_information9)

Line 143: fnd_number.canonical_to_number (action_information7)

139: p_curr_prev_stat VARCHAR2,
140: p_leagal_employer_id VARCHAR2
141: ) IS
142: SELECT fnd_number.canonical_to_number (action_information6) leave_to_work_hours,
143: fnd_number.canonical_to_number (action_information7)
144: long_leave_part,
145: fnd_number.canonical_to_number (action_information8) men_leave_to_work_hour,
146: fnd_number.canonical_to_number (action_information9)
147: women_leave_to_work_hour,

Line 145: fnd_number.canonical_to_number (action_information8) men_leave_to_work_hour,

141: ) IS
142: SELECT fnd_number.canonical_to_number (action_information6) leave_to_work_hours,
143: fnd_number.canonical_to_number (action_information7)
144: long_leave_part,
145: fnd_number.canonical_to_number (action_information8) men_leave_to_work_hour,
146: fnd_number.canonical_to_number (action_information9)
147: women_leave_to_work_hour,
148: fnd_number.canonical_to_number (action_information10) leave_to_work_hour_lower,
149: fnd_number.canonical_to_number (action_information11)

Line 146: fnd_number.canonical_to_number (action_information9)

142: SELECT fnd_number.canonical_to_number (action_information6) leave_to_work_hours,
143: fnd_number.canonical_to_number (action_information7)
144: long_leave_part,
145: fnd_number.canonical_to_number (action_information8) men_leave_to_work_hour,
146: fnd_number.canonical_to_number (action_information9)
147: women_leave_to_work_hour,
148: fnd_number.canonical_to_number (action_information10) leave_to_work_hour_lower,
149: fnd_number.canonical_to_number (action_information11)
150: leave_to_work_hour_middle,

Line 148: fnd_number.canonical_to_number (action_information10) leave_to_work_hour_lower,

144: long_leave_part,
145: fnd_number.canonical_to_number (action_information8) men_leave_to_work_hour,
146: fnd_number.canonical_to_number (action_information9)
147: women_leave_to_work_hour,
148: fnd_number.canonical_to_number (action_information10) leave_to_work_hour_lower,
149: fnd_number.canonical_to_number (action_information11)
150: leave_to_work_hour_middle,
151: fnd_number.canonical_to_number (action_information12) leave_to_work_hour_upper
152: FROM pay_action_information

Line 149: fnd_number.canonical_to_number (action_information11)

145: fnd_number.canonical_to_number (action_information8) men_leave_to_work_hour,
146: fnd_number.canonical_to_number (action_information9)
147: women_leave_to_work_hour,
148: fnd_number.canonical_to_number (action_information10) leave_to_work_hour_lower,
149: fnd_number.canonical_to_number (action_information11)
150: leave_to_work_hour_middle,
151: fnd_number.canonical_to_number (action_information12) leave_to_work_hour_upper
152: FROM pay_action_information
153: WHERE action_context_type = 'PA'

Line 151: fnd_number.canonical_to_number (action_information12) leave_to_work_hour_upper

147: women_leave_to_work_hour,
148: fnd_number.canonical_to_number (action_information10) leave_to_work_hour_lower,
149: fnd_number.canonical_to_number (action_information11)
150: leave_to_work_hour_middle,
151: fnd_number.canonical_to_number (action_information12) leave_to_work_hour_upper
152: FROM pay_action_information
153: WHERE action_context_type = 'PA'
154: AND action_context_id = csr_v_pa_id
155: AND action_information_category = 'EMEA REPORT INFORMATION'