eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_RUNGEN dependencies on FND_DATE

Line 68: AND fnd_date.canonical_to_date(p_payact_earned_date)

64: FROM pay_element_entries_f ELE,
65: pay_element_entry_values_f EEV,
66: pay_input_values_f IPV
67: WHERE ELE.assignment_id = asgrec.assignment_id
68: AND fnd_date.canonical_to_date(p_payact_earned_date)
69: BETWEEN ELE.effective_start_date
70: AND ELE.effective_end_date
71: AND EEV.element_entry_id = ELE.element_entry_id
72: AND NVL(EEV.screen_entry_value,'N') = 'Y'

Line 73: AND fnd_date.canonical_to_date(p_payact_earned_date)

69: BETWEEN ELE.effective_start_date
70: AND ELE.effective_end_date
71: AND EEV.element_entry_id = ELE.element_entry_id
72: AND NVL(EEV.screen_entry_value,'N') = 'Y'
73: AND fnd_date.canonical_to_date(p_payact_earned_date)
74: BETWEEN EEV.effective_start_date
75: AND EEV.effective_end_date
76: AND IPV.input_value_id = EEV.input_value_id
77: AND UPPER(IPV.name) = 'TAX SEPARATELY'

Line 86: AND fnd_date.canonical_to_date(p_payact_earned_date)

82: WHERE ELE2.assignment_id
83: = asgrec.assignment_id
84: AND ELE2.element_entry_id
85: = ELE.element_entry_id
86: AND fnd_date.canonical_to_date(p_payact_earned_date)
87: BETWEEN ELE2.effective_start_date
88: AND ELE2.effective_end_date
89: AND EEV2.element_entry_id
90: = ELE2.element_entry_id

Line 92: AND fnd_date.canonical_to_date(p_payact_earned_date)

88: AND ELE2.effective_end_date
89: AND EEV2.element_entry_id
90: = ELE2.element_entry_id
91: AND EEV2.screen_entry_value = 'N'
92: AND fnd_date.canonical_to_date(p_payact_earned_date)
93: BETWEEN EEV2.effective_start_date
94: AND EEV2.effective_end_date
95: AND IPV2.input_value_id
96: = EEV2.input_value_id

Line 110: AND fnd_date.canonical_to_date(p_payact_earned_date)

106: FROM pay_element_entries_f ELE,
107: pay_element_entry_values_f EEV,
108: pay_input_values_f IPV
109: WHERE ELE.assignment_id = asgrec.assignment_id
110: AND fnd_date.canonical_to_date(p_payact_earned_date)
111: BETWEEN ELE.effective_start_date
112: AND ELE.effective_end_date
113: AND EEV.element_entry_id = ELE.element_entry_id
114: AND EEV.screen_entry_value <> 'A'

Line 115: AND fnd_date.canonical_to_date(p_payact_earned_date)

111: BETWEEN ELE.effective_start_date
112: AND ELE.effective_end_date
113: AND EEV.element_entry_id = ELE.element_entry_id
114: AND EEV.screen_entry_value <> 'A'
115: AND fnd_date.canonical_to_date(p_payact_earned_date)
116: BETWEEN EEV.effective_start_date
117: AND EEV.effective_end_date
118: AND IPV.input_value_id = EEV.input_value_id
119: AND UPPER(IPV.name) = 'DEDUCTION PROCESSING'

Line 127: AND fnd_date.canonical_to_date(p_payact_earned_date)

123: pay_input_values_f IPV2
124: WHERE ELE2.assignment_id = asgrec.assignment_id
125: AND ELE2.element_entry_id
126: = ELE.element_entry_id
127: AND fnd_date.canonical_to_date(p_payact_earned_date)
128: BETWEEN ELE2.effective_start_date
129: AND ELE2.effective_end_date
130: AND EEV2.element_entry_id
131: = ELE2.element_entry_id

Line 133: AND fnd_date.canonical_to_date(p_payact_earned_date)

129: AND ELE2.effective_end_date
130: AND EEV2.element_entry_id
131: = ELE2.element_entry_id
132: AND EEV2.screen_entry_value = 'N'
133: AND fnd_date.canonical_to_date(p_payact_earned_date)
134: BETWEEN EEV2.effective_start_date
135: AND EEV2.effective_end_date
136: AND IPV2.input_value_id
137: = EEV2.input_value_id

Line 146: AND fnd_date.canonical_to_date(p_payact_earned_date)

142: pay_input_values_f IPV3
143: WHERE ELE3.assignment_id = asgrec.assignment_id
144: AND ELE3.element_entry_id
145: = ELE.element_entry_id
146: AND fnd_date.canonical_to_date(p_payact_earned_date)
147: BETWEEN ELE3.effective_start_date
148: AND ELE3.effective_end_date
149: AND EEV3.element_entry_id
150: = ELE3.element_entry_id

Line 152: AND fnd_date.canonical_to_date(p_payact_earned_date)

148: AND ELE3.effective_end_date
149: AND EEV3.element_entry_id
150: = ELE3.element_entry_id
151: AND EEV3.screen_entry_value = 'N'
152: AND fnd_date.canonical_to_date(p_payact_earned_date)
153: BETWEEN EEV3.effective_start_date
154: AND EEV3.effective_end_date
155: AND IPV3.input_value_id
156: = EEV3.input_value_id

Line 170: AND fnd_date.canonical_to_date(p_payact_earned_date)

166: FROM pay_element_entries_f ELE,
167: pay_element_entry_values_f EEV,
168: pay_input_values_f IPV
169: WHERE ELE.assignment_id = asgrec.assignment_id
170: AND fnd_date.canonical_to_date(p_payact_earned_date)
171: BETWEEN ELE.effective_start_date
172: AND ELE.effective_end_date
173: AND EEV.element_entry_id = ELE.element_entry_id
174: AND EEV.screen_entry_value <> 'A'

Line 175: AND fnd_date.canonical_to_date(p_payact_earned_date)

171: BETWEEN ELE.effective_start_date
172: AND ELE.effective_end_date
173: AND EEV.element_entry_id = ELE.element_entry_id
174: AND EEV.screen_entry_value <> 'A'
175: AND fnd_date.canonical_to_date(p_payact_earned_date)
176: BETWEEN EEV.effective_start_date
177: AND EEV.effective_end_date
178: AND IPV.input_value_id = EEV.input_value_id
179: AND UPPER(IPV.name) = 'DEDUCTION PROCESSING'

Line 187: AND fnd_date.canonical_to_date(p_payact_earned_date)

183: pay_input_values_f IPV2
184: WHERE ELE2.assignment_id = asgrec.assignment_id
185: AND ELE2.element_entry_id
186: = ELE.element_entry_id
187: AND fnd_date.canonical_to_date(p_payact_earned_date)
188: BETWEEN ELE2.effective_start_date
189: AND ELE2.effective_end_date
190: AND EEV2.element_entry_id
191: = ELE2.element_entry_id

Line 193: AND fnd_date.canonical_to_date(p_payact_earned_date)

189: AND ELE2.effective_end_date
190: AND EEV2.element_entry_id
191: = ELE2.element_entry_id
192: AND EEV2.screen_entry_value = 'N'
193: AND fnd_date.canonical_to_date(p_payact_earned_date)
194: BETWEEN EEV2.effective_start_date
195: AND EEV2.effective_end_date
196: AND IPV2.input_value_id
197: = EEV2.input_value_id

Line 206: AND fnd_date.canonical_to_date(p_payact_earned_date)

202: pay_input_values_f IPV3
203: WHERE ELE3.assignment_id = asgrec.assignment_id
204: AND ELE3.element_entry_id
205: = ELE.element_entry_id
206: AND fnd_date.canonical_to_date(p_payact_earned_date)
207: BETWEEN ELE3.effective_start_date
208: AND ELE3.effective_end_date
209: AND ELI3.element_link_id
210: = ELE3.element_link_id

Line 211: AND fnd_date.canonical_to_date(p_payact_earned_date)

207: BETWEEN ELE3.effective_start_date
208: AND ELE3.effective_end_date
209: AND ELI3.element_link_id
210: = ELE3.element_link_id
211: AND fnd_date.canonical_to_date(p_payact_earned_date)
212: BETWEEN ELI3.effective_start_date
213: AND ELI3.effective_end_date
214: AND IPV3.element_type_id
215: = ELI3.element_type_id

Line 309: AND fnd_date.canonical_to_date(p_payact_earned_date)

305: FROM pay_element_entries_f ELE,
306: pay_element_entry_values_f EEV,
307: pay_input_values_f IPV
308: WHERE ELE.assignment_id = asgrec.assignment_id
309: AND fnd_date.canonical_to_date(p_payact_earned_date)
310: BETWEEN ELE.effective_start_date
311: AND ELE.effective_end_date
312: AND EEV.element_entry_id = ELE.element_entry_id
313: AND NVL(EEV.screen_entry_value,'N') = 'Y'

Line 314: AND fnd_date.canonical_to_date(p_payact_earned_date)

310: BETWEEN ELE.effective_start_date
311: AND ELE.effective_end_date
312: AND EEV.element_entry_id = ELE.element_entry_id
313: AND NVL(EEV.screen_entry_value,'N') = 'Y'
314: AND fnd_date.canonical_to_date(p_payact_earned_date)
315: BETWEEN EEV.effective_start_date
316: AND EEV.effective_end_date
317: AND IPV.input_value_id = EEV.input_value_id
318: AND UPPER(IPV.name) = 'SEPARATE CHECK';

Line 616: and effective_date = fnd_date.canonical_to_date(p_date_paid)

612: from pay_payroll_actions
613: where target_payroll_action_id = p_primary_action_id
614: and payroll_id = p_payroll_id
615: and action_type = 'R'
616: and effective_date = fnd_date.canonical_to_date(p_date_paid)
617: and legislative_parameters like '%SPECIALPROC%'
618: order by action_sequence;
619: --
620: l_req_id number;

Line 654: and effective_date = fnd_date.canonical_to_date(p_date_paid)

650: from pay_payroll_actions
651: where target_payroll_action_id = p_primary_action_id
652: and payroll_id = p_payroll_id
653: and action_type = 'R'
654: and effective_date = fnd_date.canonical_to_date(p_date_paid)
655: and legislative_parameters like '%SEPCHECK%'
656: order by action_sequence;
657: --
658: l_req_id number;

Line 719: AND effective_date = fnd_date.canonical_to_date(p_date_paid);

715: FROM pay_payroll_actions
716: WHERE request_id = l_req_id
717: AND payroll_id = p_payroll_id
718: AND action_type = 'P'
719: AND effective_date = fnd_date.canonical_to_date(p_date_paid);
720: --
721: update pay_payroll_actions
722: set consolidation_set_id = p_master_con_set_id
723: where payroll_action_id = actrec.payroll_action_id;

Line 829: AND effective_date = fnd_date.canonical_to_date(p_date_paid);

825: FROM pay_payroll_actions
826: WHERE request_id = l_req_id
827: AND payroll_id = p_payroll_id
828: AND action_type = 'R'
829: AND effective_date = fnd_date.canonical_to_date(p_date_paid);
830: --
831: perform_prepay (p_payroll_id,
832: l_sc_consoset_id,
833: p_date_paid,

Line 844: AND effective_date = fnd_date.canonical_to_date(p_date_paid);

840: FROM pay_payroll_actions
841: WHERE request_id = l_req_id
842: AND payroll_id = p_payroll_id
843: AND action_type = 'P'
844: AND effective_date = fnd_date.canonical_to_date(p_date_paid);
845: --
846: -- Update the actions with the new details.
847: UPDATE pay_payroll_actions
848: SET consolidation_set_id = p_consolidation_set_id,

Line 941: AND effective_date = fnd_date.canonical_to_date(p_date_paid);

937: FROM pay_payroll_actions
938: WHERE request_id = l_req_id
939: AND payroll_id = p_payroll_id
940: AND action_type = 'R'
941: AND effective_date = fnd_date.canonical_to_date(p_date_paid);
942: --
943: -- Update the actions with the new details.
944: UPDATE pay_payroll_actions
945: SET assignment_set_id = NULL,

Line 1034: AND effective_date = fnd_date.canonical_to_date(p_date_paid);

1030: FROM pay_payroll_actions
1031: WHERE request_id = l_req_id
1032: AND payroll_id = p_payroll_id
1033: AND action_type = 'R'
1034: AND effective_date = fnd_date.canonical_to_date(p_date_paid);
1035: --
1036: l_primary_action := l_payact_id;
1037: --
1038: -- Update payroll action with pay advice message.

Line 1059: fnd_date.canonical_to_date(date_earned),

1055: l_primary_action := p_pay_action_id;
1056: --
1057: select payroll_id,
1058: consolidation_set_id,
1059: fnd_date.canonical_to_date(date_earned),
1060: fnd_date.canonical_to_date(effective_date),
1061: assignment_set_id,
1062: element_set_id,
1063: business_group_id

Line 1060: fnd_date.canonical_to_date(effective_date),

1056: --
1057: select payroll_id,
1058: consolidation_set_id,
1059: fnd_date.canonical_to_date(date_earned),
1060: fnd_date.canonical_to_date(effective_date),
1061: assignment_set_id,
1062: element_set_id,
1063: business_group_id
1064: into l_payroll_id,