DBA Data[Home] [Help]

APPS.PAY_SIMULATOR_SS_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 556: , per_all_assignments_f paf

552: , ptp.end_date
553: , ptp.regular_payment_date
554: FROM pay_all_payrolls_f papf
555: , per_time_periods ptp
556: , per_all_assignments_f paf
557: WHERE papf.payroll_id = paf.payroll_id
558: AND paf.assignment_id = p_assignment_id
559: AND trunc(sysdate)
560: BETWEEN papf.effective_start_date

Line 590: per_all_assignments_f asg,

586: cursor check_actions
587: is
588: select 1
589: from per_business_groups_perf pbg,
590: per_all_assignments_f asg,
591: per_all_assignments_f as2,
592: per_periods_of_service pos
593: where asg.assignment_id = p_assignment_id
594: and pos.period_of_service_id = asg.period_of_service_id

Line 591: per_all_assignments_f as2,

587: is
588: select 1
589: from per_business_groups_perf pbg,
590: per_all_assignments_f asg,
591: per_all_assignments_f as2,
592: per_periods_of_service pos
593: where asg.assignment_id = p_assignment_id
594: and pos.period_of_service_id = asg.period_of_service_id
595: and l_date_paid between

Line 607: per_all_assignments_f as2

603: INDEX (ac2 PAY_ASSIGNMENT_ACTIONS_N1) */ null
604: from pay_action_classifications acl,
605: pay_assignment_actions ac2,
606: pay_payroll_actions pa2,
607: per_all_assignments_f as2
608: where as2.period_of_service_id = pos.period_of_service_id
609: and ac2.assignment_id = as2.assignment_id
610: and pa2.payroll_action_id = ac2.payroll_action_id
611: and acl.classification_name = 'SEQUENCED'