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_GB_TAX_CREDIT_PKG dependencies on PER_TIME_PERIODS

Line 245: from per_time_periods ptp,

241:
242: cursor c_tax_credit_prior_to_runs(p_asg in NUMBER
243: ) is
244: select 'Y'
245: from per_time_periods ptp,
246: pay_payroll_actions ppa,
247: pay_assignment_actions paa,
248: per_all_assignments_f asg
249: where asg.assignment_id = p_asg

Line 275: from per_time_periods ptp,

271:
272: cursor c_periods_left(p_asg in NUMBER,
273: p_termination_date in DATE) is
274: select count(*)
275: from per_time_periods ptp,
276: per_all_assignments_f asg
277: where asg.assignment_id = p_asg
278: and asg.payroll_id = ptp.payroll_id
279: and ptp.end_date <= p_termination_date

Line 502: from per_time_periods ptp,

498:
499: CURSOR c_before_a_payroll_run(p_asg in NUMBER
500: ) is
501: select 'Y'
502: from per_time_periods ptp,
503: pay_payroll_actions ppa,
504: per_all_assignments_f asg
505: where asg.assignment_id = p_asg
506: and asg.payroll_id = ppa.payroll_id

Line 582: INDEX(ptp PER_TIME_PERIODS_PK) */ 'Y'

578:
579: cursor c_end_date_allowed(p_asg in PAY_ELEMENT_ENTRIES_F.assignment_id%TYPE,
580: p_date in DATE) is
581: select /*+ ORDERED
582: INDEX(ptp PER_TIME_PERIODS_PK) */ 'Y'
583: from per_all_assignments_f asg,
584: pay_payroll_actions ppa,
585: per_time_periods ptp
586: where asg.assignment_id = p_asg

Line 585: per_time_periods ptp

581: select /*+ ORDERED
582: INDEX(ptp PER_TIME_PERIODS_PK) */ 'Y'
583: from per_all_assignments_f asg,
584: pay_payroll_actions ppa,
585: per_time_periods ptp
586: where asg.assignment_id = p_asg
587: and asg.payroll_id = ppa.payroll_id
588: and ptp.time_period_id = ppa.time_period_id
589: and ppa.action_type = 'R'

Line 697: per_time_periods ptp,

693: SELECT to_number(substr(max(lpad(paa.action_sequence,15,'0')||
694: paa.assignment_action_id),16))
695: FROM pay_assignment_actions paa,
696: pay_payroll_actions ppa,
697: per_time_periods ptp,
698: fnd_sessions ses
699: WHERE paa.assignment_id = p_asg
700: AND ses.session_id = userenv('sessionid')
701: AND ppa.payroll_action_id = paa.payroll_action_id

Line 722: per_time_periods ptp,

718: paa.assignment_action_id),16))
719: from pay_assignment_actions paa,
720: pay_payroll_actions ppa,
721: fnd_sessions ses,
722: per_time_periods ptp,
723: per_all_assignments per
724: where paa.assignment_id = p_asg
725: and ses.session_id = userenv('sessionid')
726: and ptp.payroll_id = ppa.payroll_id