DBA Data[Home] [Help]

APPS.PAY_CA_EMP_PRVTAX_INF_API dependencies on PER_ASSIGNMENTS_F

Line 1130: from PER_ASSIGNMENTS_F paf

1126: l_location_id number;
1127: l_country varchar2(30);
1128: cursor csr_chk_assignment is
1129: select paf.location_id
1130: from PER_ASSIGNMENTS_F paf
1131: where paf.assignment_id = p_assignment_id
1132: and p_effective_date between paf.effective_start_date and
1133: paf.effective_end_date ;
1134: cursor csr_get_location(p_location_id number) is