DBA Data[Home] [Help]

APPS.PAY_CA_PAYREG_EXTRACT_PKG dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 692: ,hr_all_organization_units_tl hou

688: ,paa_key.effective_date /* BUG: 5383895 paa_key.date_earned changed to paa_key.effective_date */
689: ,popm.defined_balance_id /* BUG: 5383895 added to avoid the cursor c_tp_pmt_check */
690: from per_all_people_f ppf
691: ,per_all_assignments_f paf
692: ,hr_all_organization_units_tl hou
693: ,pay_all_payrolls_f pap
694: ,pay_payment_types_tl ppt_tl
695: ,pay_payment_types ppt
696: ,pay_org_payment_methods_f_tl popm_tl

Line 886: select name from hr_all_organization_units_tl

882:
883: /* Query to get the payee_name for payee_type 'O'
884: Added this curosr to fix bug#2745577 */
885: cursor c_payee_org_name (cp_payee_id number) IS
886: select name from hr_all_organization_units_tl
887: where organization_id = cp_payee_id
888: and language = userenv('LANG');
889:
890: /* Query to get the payee_name for payee_type 'P'