DBA Data[Home] [Help]

APPS.PAY_JP_WIC_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 303: from hr_organization_information hoi,

299: hoi.org_information1 SALARY_PAYER_NAME_KANJI,
300: hoi.org_information2 SALARY_PAYER_NAME_KANA,
301: hoi.org_information6 || hoi.org_information7 || hoi.org_information8 SALARY_PAYER_ADDRESS_KANJI,
302: hoi.org_information9 || hoi.org_information10 || hoi.org_information11 SALARY_PAYER_ADDRESS_KANA
303: from hr_organization_information hoi,
304: pay_jp_wic_assacts_v wic
305: where wic.assignment_id = p_assignment_id
306: and wic.action_sequence < p_action_sequence
307: and wic.effective_date >= trunc(p_effective_date, 'YYYY')

Line 2419: hr_organization_information hoi,

2415: per.per_information18 LAST_NAME_KANJI,
2416: per.last_name LAST_NAME_KANA,
2417: wic.employment_category
2418: from per_all_people_f per,
2419: hr_organization_information hoi,
2420: pay_all_payrolls_f pay,
2421: /* Use V2 instead of V for debugging. */
2422: pay_jp_wic_assacts_v2 wic
2423: where wic.assignment_action_id = p_assignment_action_id