DBA Data[Home] [Help]

APPS.PAY_JP_WIC_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 348: from hr_organization_information hoi,

344: hoi.org_information1 SALARY_PAYER_NAME_KANJI,
345: hoi.org_information2 SALARY_PAYER_NAME_KANA,
346: hoi.org_information6 || hoi.org_information7 || hoi.org_information8 SALARY_PAYER_ADDRESS_KANJI,
347: hoi.org_information9 || hoi.org_information10 || hoi.org_information11 SALARY_PAYER_ADDRESS_KANA
348: from hr_organization_information hoi,
349: pay_jp_wic_assacts_v wic
350: where wic.assignment_id = p_assignment_id
351: and wic.action_sequence < p_action_sequence
352: and wic.effective_date >= trunc(p_effective_date, 'YYYY')

Line 3910: hr_organization_information hoi,

3906: per.per_information18 LAST_NAME_KANJI,
3907: per.last_name LAST_NAME_KANA,
3908: wic.employment_category
3909: from per_all_people_f per,
3910: hr_organization_information hoi,
3911: pay_all_payrolls_f pay,
3912: /* Use V2 instead of V for debugging. */
3913: pay_jp_wic_assacts_v2 wic
3914: where wic.assignment_action_id = p_assignment_action_id