eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_ACC_GEN_WF_PKG dependencies on PER_PEOPLE_F

Line 44: x_vendor_employee_id OUT NOCOPY per_people_f.person_id%TYPE,

40: x_task_organization_id OUT NOCOPY hr_organization_units.organization_id %TYPE,
41: x_task_service_type OUT NOCOPY pa_tasks.service_type_code%TYPE,
42: x_top_task_id OUT NOCOPY pa_tasks.task_id%TYPE,
43: x_top_task_number OUT NOCOPY pa_tasks.task_number%TYPE,
44: x_vendor_employee_id OUT NOCOPY per_people_f.person_id%TYPE,
45: x_vendor_employee_number OUT NOCOPY per_people_f.employee_number%TYPE,
46: x_vendor_type OUT NOCOPY po_vendors.vendor_type_lookup_code%TYPE)
47: AS
48:

Line 45: x_vendor_employee_number OUT NOCOPY per_people_f.employee_number%TYPE,

41: x_task_service_type OUT NOCOPY pa_tasks.service_type_code%TYPE,
42: x_top_task_id OUT NOCOPY pa_tasks.task_id%TYPE,
43: x_top_task_number OUT NOCOPY pa_tasks.task_number%TYPE,
44: x_vendor_employee_id OUT NOCOPY per_people_f.person_id%TYPE,
45: x_vendor_employee_number OUT NOCOPY per_people_f.employee_number%TYPE,
46: x_vendor_type OUT NOCOPY po_vendors.vendor_type_lookup_code%TYPE)
47: AS
48:
49: l_person_effective_date DATE;

Line 85: per_people_f EMP

81: x_vendor_employee_number,
82: x_vendor_type
83: FROM
84: po_vendors VEND,
85: per_people_f EMP
86: WHERE
87: VEND.vendor_id = p_vendor_id
88: AND VEND.employee_id = EMP.person_id (+)
89: AND l_person_effective_date

Line 113: per_people_f EMP

109: EMP.employee_number VENDOR_EMPLOYEE_NUMBER
110: INTO
111: x_vendor_employee_number
112: FROM
113: per_people_f EMP
114: WHERE x_vendor_employee_id = EMP.person_id
115: AND l_person_effective_date between EMP.effective_start_date
116: and NVL (EMP.effective_end_date, sysdate);
117:

Line 187: p_employee_id IN per_people_f.person_id%TYPE,

183: p_expenditure_organization_id IN hr_organization_units.organization_id%TYPE,
184: p_expenditure_item_date IN
185: pa_expenditure_items_all.expenditure_item_date%TYPE,
186: p_calling_module IN VARCHAR2,
187: p_employee_id IN per_people_f.person_id%TYPE,
188: p_employee_ccid IN OUT NOCOPY gl_code_combinations.code_combination_id%TYPE,
189: p_expense_type IN ap_expense_report_lines_all.web_parameter_id%TYPE,
190: p_expense_cc IN ap_expense_report_headers_all.flex_concatenated%TYPE,
191: x_class_code OUT NOCOPY pa_class_codes.class_code%TYPE,

Line 207: x_employee_number OUT NOCOPY per_people_f.employee_number%TYPE,

203: x_task_organization_id OUT NOCOPY hr_organization_units.organization_id%TYPE,
204: x_task_service_type OUT NOCOPY pa_tasks.service_type_code%TYPE,
205: x_top_task_id OUT NOCOPY pa_tasks.task_id%TYPE,
206: x_top_task_number OUT NOCOPY pa_tasks.task_number%TYPE,
207: x_employee_number OUT NOCOPY per_people_f.employee_number%TYPE,
208: x_vendor_type OUT NOCOPY po_vendors.vendor_type_lookup_code%TYPE,
209: x_person_type OUT NOCOPY VARCHAR2 )
210: AS
211:

Line 271: FROM per_people_f p,

267:
268: SELECT DECODE(p.current_npw_flag,'Y',p.npw_number, p.employee_number) employee_number, a.default_code_comb_id,
269: DECODE(p.current_npw_flag,'Y','CWK','EMP') person_type
270: INTO x_employee_number, l_employee_ccid, x_person_type
271: FROM per_people_f p,
272: per_assignments_f a,
273: per_assignment_status_types past
274: WHERE p.person_id = p_employee_id
275: AND p.business_group_id + 0 = (SELECT nvl(max(fsp.business_group_id),0)

Line 719: p_employee_id IN per_people_f.person_id%TYPE,

715: pa_expenditure_items_all.expenditure_item_date%TYPE,
716: p_billable_flag IN pa_tasks.billable_flag%TYPE,
717: p_chart_of_accounts_id IN NUMBER,
718: p_calling_module IN VARCHAR2,
719: p_employee_id IN per_people_f.person_id%TYPE,
720: p_employee_ccid IN gl_code_combinations.code_combination_id%TYPE,
721: p_expense_type IN ap_expense_report_lines_all.web_parameter_id%TYPE,
722: p_expense_cc IN ap_expense_report_headers_all.flex_concatenated%TYPE,
723: p_attribute_category IN ap_expense_report_headers_all.attribute_category%TYPE,

Line 793: l_employee_number per_people_f.employee_number%TYPE;

789: l_task_organization_id hr_organization_units.organization_id %TYPE;
790: l_task_service_type pa_tasks.service_type_code%TYPE;
791: l_top_task_id pa_tasks.task_id%TYPE;
792: l_top_task_number pa_tasks.task_number%TYPE;
793: l_employee_number per_people_f.employee_number%TYPE;
794: l_vendor_type po_vendors.vendor_type_lookup_code%TYPE;
795: l_error_message VARCHAR2(1000) := '';
796: l_org_id hr_organization_units.organization_id %TYPE; -- Workflow Enhancement
797:

Line 1556: l_vendor_employee_id per_people_f.person_id%TYPE;

1552: l_task_organization_id hr_organization_units.organization_id %TYPE;
1553: l_task_service_type pa_tasks.service_type_code%TYPE;
1554: l_top_task_id pa_tasks.task_id%TYPE;
1555: l_top_task_number pa_tasks.task_number%TYPE;
1556: l_vendor_employee_id per_people_f.person_id%TYPE;
1557: l_vendor_employee_number per_people_f.employee_number%TYPE;
1558: l_vendor_type po_vendors.vendor_type_lookup_code%TYPE;
1559: l_error_message VARCHAR2(1000) :='';
1560: l_accounting_date DATE;

Line 1557: l_vendor_employee_number per_people_f.employee_number%TYPE;

1553: l_task_service_type pa_tasks.service_type_code%TYPE;
1554: l_top_task_id pa_tasks.task_id%TYPE;
1555: l_top_task_number pa_tasks.task_number%TYPE;
1556: l_vendor_employee_id per_people_f.person_id%TYPE;
1557: l_vendor_employee_number per_people_f.employee_number%TYPE;
1558: l_vendor_type po_vendors.vendor_type_lookup_code%TYPE;
1559: l_error_message VARCHAR2(1000) :='';
1560: l_accounting_date DATE;
1561: l_org_id hr_organization_units.organization_id %TYPE; -- Workflow Enhancement