[Home] [Help]
553: /* Variables used to hold the current values returned within the loop for
554: checking against the new values returned from within the loop on the
555: next iteration. */
556:
557: l_prev_person_id per_all_people_f.person_id%type;
558: l_prev_tax_unit_id hr_all_organization_units.organization_id%type;
559:
560: /* Variable to hold the jurisdiction code used as a context for state
561: reporting. */
622: ASG.effective_end_date effective_end_date
623: FROM per_all_assignments_f ASG,
624: pay_assignment_actions paa,
625: pay_payroll_actions ppa,
626: per_all_people_f ppf
627: WHERE ppa.effective_date between l_period_start
628: and l_period_end
629: AND ppa.action_type in ('R','Q','V','B','I')
630: AND ppa.business_group_id +0 = l_bus_group_id
651: ASG.effective_end_date effective_end_date
652: FROM per_all_assignments_f ASG,
653: pay_assignment_actions paa,
654: pay_payroll_actions ppa,
655: per_all_people_f ppf,
656: pay_population_ranges ppr
657: WHERE ppa.effective_date between l_period_start
658: and l_period_end
659: AND ppa.action_type in ('R','Q','V','B','I')
5070: l_organization_id,
5071: l_location_id
5072: from
5073: per_all_assignments_f ASSIGN
5074: , per_all_people_f PEOPLE
5075: , per_person_types PTYPE
5076: , fnd_sessions SES
5077: where l_date_earned BETWEEN ASSIGN.effective_start_date
5078: AND ASSIGN.effective_end_date
5099: into l_employee_phone_no
5100: from per_phones PHONE ,
5101: fnd_sessions SES
5102: where PHONE.parent_id (+) = l_person_id
5103: and PHONE.parent_table (+)= 'PER_ALL_PEOPLE_F'
5104: and PHONE.phone_type (+)= 'W1'
5105: and l_date_earned BETWEEN NVL(PHONE.date_from,SES.effective_date)
5106: AND NVL(PHONE.date_to,SES.effective_date)
5107: and SES.session_id = USERENV('SESSIONID') ;