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.PAY_SOE_GLB dependencies on PER_TIME_PERIODS

Line 173: per_time_periods ptp

169: cursor csr_get_action_id (asg_id number) is
170: select to_number(substr(max(to_char(pa.effective_date,'J')||lpad(aa.assignment_action_id,15,'0')),8))
171: from pay_payroll_actions pa,
172: pay_assignment_actions aa,
173: per_time_periods ptp
174: where aa.action_status = 'C'
175: and pa.payroll_action_id = aa.payroll_action_id
176: and aa.assignment_id = asg_id
177: and ptp.payroll_id = pa.payroll_id

Line 333: ,per_time_periods tp1

329: from pay_all_payrolls_f pp1
330: ,pay_all_payrolls_f pp2
331: ,pay_payroll_actions pa1
332: ,pay_payroll_actions pa2
333: ,per_time_periods tp1
334: ,per_time_periods tp2
335: ,pay_assignment_actions aa1
336: ,pay_assignment_actions aa2
337: where pa1.payroll_action_id = aa1.payroll_action_id

Line 334: ,per_time_periods tp2

330: ,pay_all_payrolls_f pp2
331: ,pay_payroll_actions pa1
332: ,pay_payroll_actions pa2
333: ,per_time_periods tp1
334: ,per_time_periods tp2
335: ,pay_assignment_actions aa1
336: ,pay_assignment_actions aa2
337: where pa1.payroll_action_id = aa1.payroll_action_id
338: --We are considering effective_date(Date Paid) which some

Line 373: ,per_time_periods tp

369: ,fnd_date.date_to_displaydate(aa.end_date) COL06
370: ,fnd_date.date_to_displaydate(tp.start_date) COL02
371: ,tp.period_type COL07
372: from pay_payroll_actions pa
373: ,per_time_periods tp
374: ,pay_assignment_actions aa
375: where pa.payroll_action_id = aa.payroll_action_id
376: and pa.effective_date = tp.regular_payment_date
377: and pa.payroll_id = tp.payroll_id

Line 390: ,per_time_periods tp

386: ,fnd_date.date_to_displaydate(aa.end_date) COL06
387: ,fnd_date.date_to_displaydate(tp.start_date) COL02
388: ,tp.period_type COL07
389: from pay_payroll_actions pa
390: ,per_time_periods tp
391: ,pay_assignment_actions aa
392: where pa.payroll_action_id = aa.payroll_action_id
393: and pa.time_period_id = tp.time_period_id
394: and aa.assignment_action_id = :assignment_action_id';

Line 1084: FROM per_time_periods ptp,

1080:
1081: SELECT ptp.start_date
1082: ,ptp.end_date
1083: ,ptp.period_num || '/' || to_char(ptp.start_date,'YYYY')
1084: FROM per_time_periods ptp,
1085: pay_payroll_actions ppa,
1086: pay_assignment_actions paa,
1087: pay_run_results prr,
1088: pay_element_entries_f pee

Line 1106: FROM per_time_periods ptp,

1102: ) is
1103: SELECT ptp.start_date
1104: ,ptp.end_date
1105: ,ptp.period_num || '/' || to_char(ptp.start_date,'YYYY')
1106: FROM per_time_periods ptp,
1107: pay_payroll_actions ppa,
1108: pay_assignment_actions paa,
1109: pay_run_results prr,
1110: pay_element_entries_f pee

Line 1128: FROM per_time_periods ptp,

1124: ) is
1125: SELECT ptp.start_date
1126: ,ptp.end_date
1127: ,ptp.period_num || '/' || to_char(ptp.start_date,'YYYY')
1128: FROM per_time_periods ptp,
1129: pay_payroll_actions ppa,
1130: pay_assignment_actions paa,
1131: pay_run_results prr,
1132: pay_element_entries_f pee

Line 1150: FROM per_time_periods ptp,

1146: ) is
1147: SELECT ptp.start_date
1148: ,ptp.end_date
1149: ,ptp.period_num || '/' || to_char(ptp.start_date,'YYYY')
1150: FROM per_time_periods ptp,
1151: pay_payroll_actions ppa,
1152: pay_assignment_actions paa,
1153: pay_element_entries_f pee
1154: WHERE pee.element_entry_id=c_element_entry_id