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 PAY_PAYROLL_ACTIONS

Line 246: pay_payroll_actions ppa,

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
250: and asg.payroll_id = ppa.payroll_id

Line 503: pay_payroll_actions ppa,

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
507: and ptp.time_period_id = ppa.time_period_id

Line 569: from pay_payroll_actions ppa,

565: p_message out nocopy VARCHAR2) is
566:
567: cursor c_purge_allowed(p_asg in PAY_ELEMENT_ENTRIES_F.assignment_id%TYPE) is
568: select max(effective_date)
569: from pay_payroll_actions ppa,
570: pay_assignment_actions paa,
571: per_all_assignments_f asg
572: where asg.assignment_id = p_asg
573: and asg.assignment_id = paa.assignment_id

Line 584: pay_payroll_actions ppa,

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
587: and asg.payroll_id = ppa.payroll_id
588: and ptp.time_period_id = ppa.time_period_id

Line 647: from pay_payroll_actions ppa,

643:
644: cursor c_processed(p_asg in PAY_ELEMENT_ENTRIES_F.assignment_id%TYPE,
645: p_date in DATE) is
646: select 'Y'
647: from pay_payroll_actions ppa,
648: per_all_assignments_f asg
649: where asg.assignment_id = p_asg
650: and asg.payroll_id = ppa.payroll_id
651: and ppa.action_type = 'R'

Line 696: pay_payroll_actions ppa,

692: where prr.assignment_action_id in (
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')

Line 720: pay_payroll_actions ppa,

716: where prr.assignment_action_id in (
717: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||
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