APPS.PAY_GB_TAX_CREDIT_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 248: per_all_assignments_f asg

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
251: and paa.assignment_id = asg.assignment_id
252: and paa.payroll_action_id = ppa.payroll_action_id

Line 264: per_all_assignments_f asg

260: last_standard_process_date,
261: final_process_date
262: from per_periods_of_service pos,
263: fnd_sessions ses,
264: per_all_assignments_f asg
265: where asg.assignment_id = p_asg
266: and ses.session_id = userenv('sessionid')
267: and ses.effective_date between asg.effective_start_date and asg.effective_end_date
268: and asg.person_id = pos.person_id

Line 276: per_all_assignments_f asg

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
280: and ptp.end_date >= p_start_date;

Line 504: per_all_assignments_f asg

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
508: and ppa.action_type = 'R'

Line 571: per_all_assignments_f asg

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
574: and paa.payroll_action_id = ppa.payroll_action_id
575: and asg.payroll_id = ppa.payroll_id

Line 583: from per_all_assignments_f asg,

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

Line 648: per_all_assignments_f asg

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'
652: and ppa.action_status='C'