DBA Data[Home] [Help]

APPS.PAY_HR_OTC_RETRIEVAL_INTERFACE dependencies on PER_ALL_ASSIGNMENTS_F

Line 59: p_location_id IN per_all_assignments_f.location_id%TYPE,

55: RETURN batches_type_table;
56:
57: FUNCTION where_clause (
58: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,
59: p_location_id IN per_all_assignments_f.location_id%TYPE,
60: p_payroll_id IN per_all_assignments_f.payroll_id%TYPE,
61: p_organization_id IN per_all_assignments_f.organization_id%TYPE,
62: p_person_id IN per_all_people_f.person_id%TYPE,
63: p_gre_id IN hr_soft_coding_keyflex.segment1%TYPE

Line 60: p_payroll_id IN per_all_assignments_f.payroll_id%TYPE,

56:
57: FUNCTION where_clause (
58: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,
59: p_location_id IN per_all_assignments_f.location_id%TYPE,
60: p_payroll_id IN per_all_assignments_f.payroll_id%TYPE,
61: p_organization_id IN per_all_assignments_f.organization_id%TYPE,
62: p_person_id IN per_all_people_f.person_id%TYPE,
63: p_gre_id IN hr_soft_coding_keyflex.segment1%TYPE
64: )

Line 61: p_organization_id IN per_all_assignments_f.organization_id%TYPE,

57: FUNCTION where_clause (
58: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,
59: p_location_id IN per_all_assignments_f.location_id%TYPE,
60: p_payroll_id IN per_all_assignments_f.payroll_id%TYPE,
61: p_organization_id IN per_all_assignments_f.organization_id%TYPE,
62: p_person_id IN per_all_people_f.person_id%TYPE,
63: p_gre_id IN hr_soft_coding_keyflex.segment1%TYPE
64: )
65: RETURN VARCHAR2;