DBA Data[Home] [Help]

APPS.PAY_CA_PAYREG_EXTRACT_PKG dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 702: ,hr_all_organization_units_tl hou

698: ,paa_key.effective_date /* BUG: 5383895 paa_key.date_earned changed to paa_key.effective_date */
699: ,popm.defined_balance_id /* BUG: 5383895 added to avoid the cursor c_tp_pmt_check */
700: from per_all_people_f ppf
701: ,per_all_assignments_f paf
702: ,hr_all_organization_units_tl hou
703: ,pay_all_payrolls_f pap
704: ,pay_payment_types_tl ppt_tl
705: ,pay_payment_types ppt
706: ,pay_org_payment_methods_f_tl popm_tl

Line 903: select name from hr_all_organization_units_tl

899:
900: /* Query to get the payee_name for payee_type 'O'
901: Added this curosr to fix bug#2745577 */
902: cursor c_payee_org_name (cp_payee_id number) IS
903: select name from hr_all_organization_units_tl
904: where organization_id = cp_payee_id
905: and language = userenv('LANG');
906:
907: /* Query to get the payee_name for payee_type 'P'