DBA Data[Home] [Help]

APPS.PAY_HR_OTC_RETRIEVAL_INTERFACE dependencies on PER_ALL_ASSIGNMENTS_F

Line 101: p_location_id IN per_all_assignments_f.location_id%TYPE,

97: RETURN batches_type_table;
98:
99: FUNCTION where_clause (
100: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,
101: p_location_id IN per_all_assignments_f.location_id%TYPE,
102: p_payroll_id IN per_all_assignments_f.payroll_id%TYPE,
103: p_organization_id IN per_all_assignments_f.organization_id%TYPE,
104: p_person_id IN per_all_people_f.person_id%TYPE,
105: p_gre_id IN hr_soft_coding_keyflex.segment1%TYPE

Line 102: p_payroll_id IN per_all_assignments_f.payroll_id%TYPE,

98:
99: FUNCTION where_clause (
100: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,
101: p_location_id IN per_all_assignments_f.location_id%TYPE,
102: p_payroll_id IN per_all_assignments_f.payroll_id%TYPE,
103: p_organization_id IN per_all_assignments_f.organization_id%TYPE,
104: p_person_id IN per_all_people_f.person_id%TYPE,
105: p_gre_id IN hr_soft_coding_keyflex.segment1%TYPE
106: )

Line 103: p_organization_id IN per_all_assignments_f.organization_id%TYPE,

99: FUNCTION where_clause (
100: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,
101: p_location_id IN per_all_assignments_f.location_id%TYPE,
102: p_payroll_id IN per_all_assignments_f.payroll_id%TYPE,
103: p_organization_id IN per_all_assignments_f.organization_id%TYPE,
104: p_person_id IN per_all_people_f.person_id%TYPE,
105: p_gre_id IN hr_soft_coding_keyflex.segment1%TYPE
106: )
107: RETURN VARCHAR2;