[Home] [Help]
51: dpnt_effective_date date,
52: person_id number,
53: sex per_all_people_f.sex%type,
54: date_of_birth date,
55: leaving_reason per_periods_of_service.leaving_reason%type,
56: last_name per_all_people_f.per_information18%type,
57: last_name_kana per_all_people_f.last_name%type,
58: first_name per_all_people_f.per_information19%type,
59: first_name_kana per_all_people_f.first_name%type,
171: dpnt_effective_date date,
172: person_id number,
173: sex per_all_people_f.sex%type,
174: date_of_birth date,
175: leaving_reason per_periods_of_service.leaving_reason%type,
176: last_name per_all_people_f.per_information18%type,
177: last_name_kana per_all_people_f.last_name%type,
178: first_name per_all_people_f.per_information19%type,
179: first_name_kana per_all_people_f.first_name%type,
1921: end if;
1922: --
1923: p_sqlstr :=
1924: 'select /*+ ORDERED
1925: INDEX(PPOS PER_PERIODS_OF_SERVICE_N3) */
1926: distinct ppos.person_id
1927: from pay_payroll_actions ppa,
1928: per_all_people_f pp,
1929: per_periods_of_service ppos
1925: INDEX(PPOS PER_PERIODS_OF_SERVICE_N3) */
1926: distinct ppos.person_id
1927: from pay_payroll_actions ppa,
1928: per_all_people_f pp,
1929: per_periods_of_service ppos
1930: where ppa.payroll_action_id = :payroll_action_id
1931: and pp.business_group_id = ppa.business_group_id + 0
1932: and ppos.person_id = pp.person_id
1933: and ppos.business_group_id + 0 = pp.business_group_id